Install Power BI sample reports

Applies to: Configuration Manager (current branch)

You can integrate Power BI Report Server with Configuration Manager reporting. There are sample reports available for download that you can install in Configuration Manager. This article explains how to install the Power BI sample reports in Configuration Manager.

Prerequisites

• Configuration Manager reporting services point with Power BI Report Server integrated

• Microsoft Power BI Desktop (Optimized for Power BI Report Server). Use a version released between September 2019 and January 2021. For versioning information, see the Change log for Power BI Report Server.

  Important

  Use versions of Power BI Desktop:

  • That are from the Microsoft Download Center. Don't use a version from the Microsoft Store
  • That states they're Optimized for Power BI Report Server. Don't use versions that aren't Optimized for Power BI Report Server.
  • That were released no earlier than September 2019 and no later than January 2021. Microsoft Power BI Desktop (Optimized for Power BI Report Server - January 2021) is recommended.

Download the sample reports

To download the sample reports:

1. Download the Power BI sample reports from the Microsoft Download Center.

2. Save the ConfigMgrSamplePowerBIReports.exe file.

3. Move the file to a computer with Microsoft Power BI Desktop (Optimized for Power BI Report Server) installed if you downloaded it from a different device.

4. Run the ConfigMgrSamplePowerBIReports.exe file to extract the .pbit files.

Note

Some of the sample reports are also available for download in Community hub.

Install the sample reports

To install the sample reports:

1. On the Power BI Report server, create a new folder called Sample Reports in the root Configuration Manager reporting folder.

   

2. Launch Microsoft Power BI Desktop (Optimized for Power BI Report Server).

3. Select File then Open and navigate to where you saved the extracted .pbit files.

4. Select one of the .pbit files you extracted from the ConfigMgrSamplePowerBIReports.exe file.

5. Specify your Configuration Manager database name and database server name when prompted, then select Load.

   

   Note

   When loading or applying the data model, ignore any errors if you come across one. For example, if you see the following error: "Connecting to tables from more than one database isn't supported in DirectQuery mode", select Close. Then refresh the data source settings:

   1. In Power BI Desktop, in the ribbon, select Edit Queries, and then select Data source settings.
   2. Select Change Source, confirm your server and database names, and select OK.
   3. Close the data source settings window, and then select Apply changes.

6. When the report data is loaded, select File > Save As, then select Power BI Report Server.

   

7. Save the report to the Sample Reports folder you created on the reporting point.

   

8. Repeat the steps for any other sample reports. When you're done, close Microsoft Power BI Desktop (Optimized for Power BI Report Server).

9. In the Configuration Manager console, go to Monitoring > Power BI Reports > Sample Reports.

10. Right-click on one of the reports and select Run in Browser to launch the report.

    

Sample reports

The following sample Power BI reports are included in the download:

• Software Update Compliance Status
• Software Update Deployment Status
• Client Status
• Content Status
• Microsoft Edge Management