SharePoint 2013 correlation id not found on SharePoint farm – Enable job Diagnostic Data Provider: Trace Log and query view ULSTraceLog

Today for one of the SSRS report (SharePoint integrated) the export to Excel failed and it gave the correlation id which we were unable to find on the various nodes of SharePoint farm.

So using Central Admin we enabled job “Diagnostic Data Provider: Trace Log” by navigating to Monitoring => Review Job definitions. On SQL server execute following query against view Logging.dbo.ULSTraceLog:

SELECT [MachineName],
[Area],
[Category],
[Level],
[EventId],
[Message],
[CorrelationId]
FROM ULSTraceLog
WHERE [CorrelationId] = ‘9990009d-cccc-xxxx-07xx-xx99f9999xx9’

Power BI Report Server Install Notes

System Requirements

Supported Operating System

Windows 8, Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016.

You’ll need:

  • NET Framework 4.5.2 or later. (You can confirm this if you see Full subkey at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full)
  • SQL Server Database Engine (2008 or later), to store the report server database.
  • SQL Server Analysis Services (2012 SP1 CU4 or later), to store your data models

Downloaded Microsoft Power BI Report Server – May 2017 Preview

Install Instructions:

  1. Install Power BI Report Server (PowerBIReportServer.exe).
  2. Configure your Power BI Report Server using Report Server Configuration Manager.
  3. Install Power BI Desktop (PBIDesktopRS_x64.msi)

Install Power BI Report Server (PowerBIReportServer.exe)

Step 1: Download

Download the installation files, for Power BI Report Server, locally. To download Power BI Report Server, go to the Microsoft download center.

Download Power BI Report Server

Step 2: Run installer

Run the PowerBIReportServer.exe file that you downloaded and step through the installation screens. You will have the opportunity to select the the installation path as well as select the edition you want to install. You can choose between an evaluation that expires within 180 days, a developer edition or to provide a product key.

Install Power BI Report Server

Step 3: Configure the server

After you are done installing, you will run the configuration manager to finish setting up your server. You will need to create a ReportServer catalog database as well as confirm the web portal and web service URLs.

Configure Power BI Report Server

How to Configure Power BI Report server

  • Configure Web Service URL. By default it’s not.
  • Configure Web Portal URL. By default it’s not.
  • Configure Power BI Report server database. If it’s on separate box, you may have to change the settings for Service account from virtual to network.

Step 4: Browse to web portal

Now that you are configured, you should be able to open a browser to the web portal of your server. By default, this will be http://localhost/reports. You will also be able to browse using the machine name instead of using localhost by default, assuming you are not being blocked by any type of firewall.

Power BI Report Server web portal

How to configure firewall for Power BI Report server installed above:

1) Go to Start –> Administrative tools–> Windows Firewall with Advanced security tool.

2) Here go to Inbound Rule tab and open a new rule window. We will be creating a new rule in order to open a port for SSRS.

3) Since we have to open port for PBIRS, select the option Port in Rule type and move to the next step.

4) Select TCP and mention the port number as 80. Then move to next step.

5) Select allow the connection so that connections are allowed to PBIRS using port 80. Then move next.

6) In the profile tab, select the appropriate option as per your requirement.

7) In this final step, provide appropriate name to this rule like ReportServer (TCP on 80) and click Finish.

8) Rules are enabled by default but you can verify that by going to Inbound rules and look for the newly created rule.

 

What is Power BI Report Server

This week has started with exploration of Power BI.

We had earlier downloaded Power BI Desktop (on-premise). Today we quickly created a report going against one of the cube in SSAS 2016.

Next logical question was how to deliver them to the users – SharePoint or SharePoint integrated SSRS?

We came across a separate Power BI Report server. Power BI Report Server is a solution that customers deploy on their own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways, whether that’s viewing them in web browser, on their mobile device, or as an email in their in-box.

Came across this great page by Adam Saxton with great links:

Power BI Report Server offers a suite of products:

  • A modern web portal you can view in any modern browser. In the web portal, you can organize and display reports and KPIs. You can also store Excel workbooks on the portal.
  • Power BI reports, created with Power BI Desktop, that you can view within the web portal in your own environment.
  • Paginated reports so you can create modern-looking reports, with tools for creating them.
  • Mobile reports with a responsive layout that adapts to different devices and the different ways you hold them.

Read on for more about each.

What’s new in Power BI Report Server

These sources will keep you up-to-date on new features in Power BI Report Server.

Web portal

For end users of Power BI Report Server, the front door is a modern web portal you can view in any modern browser. You can access all your reports and KPIs in the new portal.

You can apply your own custom branding to your web portal. And you can create KPIs right in the web portal. KPIs can surface key business metrics at a glance in the browser, without having to open a report.

The content on the web portal is organized by type: Power BI reports, mobile reports, paginated reports and KPIs, plus Excel workbooks, shared datasets, and shared data sources to use as building blocks for your reports. You can store and manage them securely here, in the traditional folder hierarchy. You can tag your favorites, and you can manage the content if you have that role.

And you can schedule report processing, access reports on demand, and subscribe to published reports in the new web portal.

More about the Web portal.

Power BI reports

A Power BI report is a multi-perspective view into a dataset, with visualizations that represent different findings and insights from that dataset. A report can have a single visualization or pages full of visualizations. Depending on your job role, you may be someone who creates reports and/or you may be someone who consumes or uses reports.

Reports are based on a single dataset. The visualizations in a report each represent a nugget of information. And the visualizations aren’t static; you can add and remove data, change visualization types, and apply filters and slicers as you dig into the data to discover insights and look for answers. Like a dashboard, but more-so, a report is highly interactive and highly customizable and the visualizations update as the underlying data changes.

Paginated reports

Paginated reports are paginated document-style reports, in which the more data you have, the more rows in the tables, and the more pages the report would have. That’s great for generating fixed-layout, pixel-perfect documents optimized for printing, such as PDF and Word files.

You can create modern-looking reports using Report Builder or Report Designer in SQL Server Data Tools (SSDT).

Report Server programming features

Take advantage of Power BI Report Server programming features so you can extend and customize your reporting functionality, with APIs to integrate or extend data and report processing in custom applications.

More Report Server developer documentation.

Next steps

User handbook
Administrator handbook
Quickstart: Install Power BI Report Server
Install Report Builder

What is Microsoft Power BI?

What is Microsoft Power BI?

Power BI is a cloud-based business analytics service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.

What is Power BI Desktop?

Power BI Desktop is a free desktop application you can install right on your own computer. Power BI Desktop works cohesively with the Power BI service by providing advanced data exploration, shaping, modeling, and report creation with highly interactive visualizations. You can save your work to a file, and publish your data and reports right to your Power BI site to share with others.

Is Power BI available on-premises?

No, Power BI is not available as a private, internal cloud service. However, with Power BI and Power BI Desktop, you can securely connect to your own on-premises data sources. With the On-premises Data Gateway, you can connect live to your on-premises SQL Server Analysis Services server, and other data sources. You can also schedule refresh with a centralized gateway. If a gateway is not available, you can refresh data from on-premises data sources using the Power BI Gateway – Personal.

You can also view on-premises SQL Server mobile reports with the Power BI iOS apps:

  • SQL Server mobile reports on the iPhone.
  • SQL Server mobile reports on the iPad

What do I need to install in order to use Power BI?

To use the Power BI service for free, you just need a Web browser and email.

To explore data and create reports in Power BI Desktop, download Power BI Desktop for free.

You can download the Power BI mobile apps from their respective stores:

  • App Store
  • Google Play
  • Windows Store

Reference: powerbi.microsoft.com