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.
Power BI Report Server license. For more information, see Licensing Power BI Report Server.
Download Microsoft Power BI Report Server-September 2019, or later.
Don't install Power BI Report Server right away. For the proper process based on your environment, see Configure the reporting services point.
- Only use versions of Power BI Desktop from the Microsoft Download Center, don't use a version from the Microsoft Store.
- Only use a version of Power BI Desktop that states it's Optimized for Power BI Report Server.
Power BI integration uses the same role-based administration for reporting.
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:
In Reporting Server Configuration Manager, back up the Encryption Keys. For more information, see SSRS Encryption Keys - Back Up and Restore Encryption Keys.
If you skip this step, you'll lose access to any custom reports in SQL Server Reporting Services.
Remove the reporting services point role from the site.
Uninstall SQL Server Reporting Services, but keep the database.
Install Power BI Report Server.
Configure the Power BI Report Server
Use the previous report server database.
Use Reporting Server Configuration Manager to restore the Encryption Keys.
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:
Install Power BI Report Server.
Add the reporting services point role in Configuration Manager. For more information, see Configure reporting.
Configure the Configuration Manager console
On a computer that has the Configuration Manager console, update the Configuration Manager console to the latest version.
Install Power BI Desktop. Make sure the language is the same.
After it installs, launch Power BI Desktop at least once before you open the Configuration Manager console.
Create Power BI reports
In the Configuration Manager console, go to the Monitoring workspace, expand Reporting, and select the new Power BI Reports node.
In the ribbon, select Create Report. This action opens Power BI Desktop.
Create a report in Power BI Desktop.
In Power BI Desktop, when you connect to a data source, select DirectQuery for the Connection settings.
Only use supported SQL views in these reports. For more information, see Creating custom reports by using SQL Server views in Configuration Manager.
When the report is ready to save, go to the File menu, select Save as, then choose Power BI Report Server.
In the Power BI Report Server Selection window, enter the URL for the reporting services point as the New report server address. For example,
In the Configuration Manager console, you see the new report in the list of Power BI Reports.
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:
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.