Download Power BI Reports from Community Hub Free

Did you know that you can download Power BI reports from Community Hub. Yes, Configuration Manager Community hub now supports contributing and downloading Power BI report template files. This integration allows administrators to easily share and reuse Power BI reports.

You can also contribute and download Power BI report template if you are using current branch versions of Configuration Manager.

Before you download the Power BI reports, ensure you have turned on the ConfigMgr Community Hub feature. Without that, you cannot browse anything within the community hub.

You must also install WebView2 Extension that is required for opening the Community Hub within Configuration Manager console.

Download Power BI Reports from Community Hub

The steps to download Power BI reports from Community Hub are as follows.

  • Launch the SCCM console, go to Community > Community hub.
  • From All objects, choose a Power BI report template, then select Download.
  • Save the Power BI report template and open the report with Power BI Desktop.
  • Specify your Configuration Manager database name and database server name when prompted, then select Load.
  • Save the final report and close the Power BI Desktop.

In the Community Hub there are just few Power BI reports. More reports could be added in the future. You can choose the report and click download. Use the search box to look for Power BI reports.

Download Power BI Reports from Community Hub
Download Power BI Reports from Community Hub

Select a Power BI report template and click Download.

Download Power BI Reports from Community Hub
Download Power BI Reports from Community Hub

Save the report template.

Download SCCM Power BI Reports from Community Hub
Download SCCM Power BI Reports from Community Hub

Now you should see Download Success. You have successfully downloaded SCCM Power BI Reports from Community Hub.

Download SCCM Power BI Reports from Community Hub
Download Power BI Reports from Community Hub

After you download the report, you can open it with Power BI Desktop application. You may see a Potential security risk warning. This file uses multiple data sources. Information is one data source might be shared with other data sources without your knowledge. Only open this file if you trust the sender. Do you want to open this file? Click OK.

Edit the Power BI Report
Edit the Power BI Report

Enter the ConfigMgr Database Server Name and ConfigMgr Database Name and click Load.

Software Update Deployment Report
Software Update Deployment Report

You will be prompted with Native Database Query window several times. Click Run every time you see query window.

Native Database Query
Native Database Query

After the report is loaded, you can first save the report. From the Power BI desktop application, click File > Save as and save the report. You can save the report to a folder on the root Configuration Manager reporting folder on the reporting point.

Download Power BI Reports from Community Hub
Download Power BI Reports from Community Hub

Need Assistance?

Send us a message or post your question in forums.

Leave a Comment