Install Power BI sample reports

Applies to: Configuration Manager (current branch)

Starting in version 2002, 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

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.

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.

    Creating the Sample Report folder in the root Configuration Manager reporting folder from

  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.

    Specify the database and database server name

    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.

    Save as Power BI Report Server

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

    Save to the Sample Reports folder

  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.

    Run the sample report from the Configuration Manager console