SCCM Power BI Dashboard Install And Configure

SCCM Power BI Dashboard Install And Configure (Simple).

The template is free to download. You can download the SCCM Power BI solution template here. A Power BI SCCM Dashboard provides high level overview of key SCCM metrics.

SCCM Power BI Dashboard Prerequisites

  • System Center 2012 Configuration Manager R2 SP1 (5.00.8239.1000) or later. Read access to System Center Configuration Manager database is required.
  • Destination database: Azure SQL database or SQL Server database (SQL Server 2008 R2 SP3 or later).
  • For the machine where the installation is run,
    • Microsoft .NET Framework 4.5 or later.
    • PowerShell version 5.0 or later.
    • For Operating System: Windows Server 2008 R2 SP1, or later. Windows 7 Professional, Enterprise, or later. Note that Windows 10 anniversary update (1607 or later) is not supported at this moment because of a bug in credential guard.

SCCM Power BI Dashboard Installation and Configuration

The SCCM Power BI solution template download has been moved to GITHub. You will find two templates. Download the one that you require and copy to target location.

  • SCCMSolutionTemplate.pbix
  • SCCMSolutionTemplateAS.pbix

SCCM Power BI Dashboard Configuration

1. Open copied template file (SCCMSolutionTemplate.pbix) with Power BI Desktop;

2. Sign in to Power BI;

3. On the menu bar, click Edit Queries and then click Data source settings;

4. Click Change Source and enter your sccm server and database;

5. Click Edit permissions and click Edit. Enter username which has rights to database.

6. Click Close and click Apply Changes;

7. Ready;

You might also like

Leave a Reply

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More