Integrate with Power BI Report Server

Applies to: Configuration Manager (current branch)

Starting in version 2002, you can integrate Power BI Report Server with Configuration Manager reporting. This integration gives you modern visualization and better performance. It adds console support for Power BI reports similar to what already exists with SQL Server Reporting Services.

Save Power BI Desktop report files (.PBIX) and deploy them to the Power BI Report Server. This process is similar as with SQL Server Reporting Services report files (.RDL). You can also launch the reports in the browser directly from the Configuration Manager console.

Prerequisites

Configure the reporting services point

This process varies depending upon whether you already have this role in the site.

You have a reporting services point

Only use this process if you already have a reporting services point in the site. Do all steps of this process on the same server:

  1. In Reporting Server Configuration Manager, back up the Encryption Keys. For more information, see SSRS Encryption Keys - Back Up and Restore Encryption Keys.

    Warning

    If you skip this step, you'll lose access to any custom reports in SQL Server Reporting Services.

  2. Remove the reporting services point role from the site.

  3. Uninstall SQL Server Reporting Services, but keep the database.

  4. Install Power BI Report Server.

  5. Configure the Power BI Report Server

    1. Use the previous report server database.

    2. Use Reporting Server Configuration Manager to restore the Encryption Keys.

  6. Add the reporting services point role in Configuration Manager.

You don't have a reporting services point

Only use this process if you don't already have a reporting services point in the site. Do all steps of this process on the same server:

  1. Install Power BI Report Server.

  2. Add the reporting services point role in Configuration Manager. For more information, see Configure reporting.

Configure the Configuration Manager console

  1. On a computer that has the Configuration Manager console, update the Configuration Manager console to the latest version.

  2. Install Power BI Desktop. Make sure the language is the same.

  3. After it installs, launch Power BI Desktop at least once before you open the Configuration Manager console.

Create Power BI reports

  1. In the Configuration Manager console, go to the Monitoring workspace, expand Reporting, and select the new Power BI Reports node.

  2. In the ribbon, select Create Report. This action opens Power BI Desktop.

  3. Create a report in Power BI Desktop.

  4. When the report is ready to save, go to the File menu, select Save as, then choose Power BI Report Server.

  5. In the Power BI Report Server Selection window, enter the URL for the reporting services point as the New report server address. For example, https://rsp.contoso.com/Reports.

In the Configuration Manager console, you see the new report in the list of Power BI Reports.

Next steps

After you create a report, use the following actions in the Configuration Manager console:

  • Run in Browser: Opens the Power BI report in the web browser. Share this URL with others, for example: https://rsp.contoso.com/Reports/POWERBI/ConfigMgr_ABC/Windows%2010/Windows10%20Dashboard?rs:embed=true

    Tip

    You can only view these reports in the web browser.

  • Edit: Make changes to the report in Power BI Desktop. For an existing report, use the Save option to save changes back to the report server.

For more information on log files to use for reporting, see Log file reference - Reporting.