How to install and configure SCCM Power BI Dashboard

Benoit LecoursPowerBI, SCCM5 Comments

Last September, the Power BI solution template for System Center Configuration Manager was released. The SCCM Power BI Dashboard provides detailed information of your SCCM hierarchy including client and server health, malware protection, software updates, and software inventory. Better late than never, we decided to do a blog post on how to link your SCCM server to Power BI and install the SCCM Power BI Dashboard. The SCCM Dashboard will show data as soon as you finish this wizard. You’ll also be able to build your own Power BI reports and publish it if you have a valid Power BI license.

If you are not familiar with Power BI, you can read the FAQ which has answers to the most common questions.

SCCM Power BI Dashboard System Requirements

  • SCCM 2012 R2 SP1 (5.00.8239.1000) or later
    • An account with Read access to SCCM database is required
  • Destination database: Azure SQL database or SQL Server database (SQL Server 2008 R2 SP3 or later)
  • Valid Work email address
  • On 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
  • PowerBI Desktop (free) to open SCCM PoweerBI Dashboard and edit further reports
  • PowerBI Pro license (if you want to share your reports only)
    • 60 days free trial version is available here

Power BI Desktop Installation

The installation wizard will get us through the process of entering the information about our SCCM, SQL Server and/or Azure environment in order to establish a connection for Power BI. At the end of the process, the Template file (Dashboard) will be available to download and use.

We will start by installing Power BI Desktop:

SCCM Power BI Dashboard

  • Accept the license terms and click Next

SCCM Power BI Dashboard

  • Select the Installation Directory and click Next

SCCM Power BI Dashboard

  • Click Install

SCCM Power BI Dashboard

  • Wait for the process to finish and close the installation wizard

SCCM Power BI Dashboard

SCCM Power BI Dashboard

Power BI Integration

We will now download and configure the Power BI integration

SCCM Power BI Dashboard

  • On the Getting Started pane, click Sign In

SCCM Power BI Dashboard

  • The Office 365 portal pops-up, select your work email account and enter your credential if you’re not already logged-in

SCCM Power BI Dashboard

  • On the Business Platform Solution Template screen, click Accept

SCCM Power BI Dashboard

  • Once back on the Getting Started pane, click on the Download button

SCCM Power BI Dashboard

  • This will download the SCCM-Template.exe file. Once downloaded, launch the executable

SCCM Power BI Dashboard

  • Wait for the process to complete

SCCM Power BI Dashboard

  • The installation wizard will launch in new window, click Next

SCCM Power BI Dashboard

  • On the Login pane, Enter your credentials to connect to the SCCM database. These credentials will also be used to run a Powershell script on a recurring schedule. Click on Validate, then Next

SCCM Power BI Dashboard

  • In the Source pane, enter your SCCM server name, click on Validate, select your Database from the drop-down then Next

SCCM Power BI Dashboard

  • On the Target pane, select your SQL Server, click on Validate, select your Database from the drop-down then Next
    • If you are using Azure SQL (which is unlikely for an SCCM installation), check the Using Azure SQL box

SCCM Power BI Dashboard

  • The 5,6,7 and 8 steps will be automatically skipped

SCCM Power BI Dashboard

  • On the Customize pane, select the time you wish to have your scheduled task to be run and the desired Compliance Target number, click on Validate and Next

SCCM Power BI Dashboard

  • Review your choices, enter your email address if desired to receive information about Power Bi and click Run

SCCM Power BI Dashboard

  • The installation starts. The initial synchronization pulls data out of Configuration Manager database and pushes the data into the specified SQL Database

SCCM Power BI Dashboard

  • Once the process is completed, you can download the Power BI SCCM Dashboard by clicking on Download Report

SCCM Power BI Dashboard

  • Once downloaded, open the SolutionTemplate.pbix file, it will open in Power BI Desktop
  • One last step needs to be done in order for the data to populate. On the top ribbon, click on Edit Query and select Data Source Settings

SCCM Power BI Dashboard

  • Click on any query on the left pane and select Edit Credentials

SCCM Power BI Dashboard

  • Select your preferred credential method and click Connect

SCCM Power BI Dashboard

  • If you have an Encryption Support warning, click OK to accept the unencrypted connection

SCCM Power BI Dashboard

  • If your credential has the Read right on the SCCM database, all the “!” icons will turn to tables icons. This means that the data can be read.

SCCM Power BI Dashboard

  • Click the Apply Changes button on the warning on the top

SCCM Power BI Dashboard

  • The magic happens! Click the Overview pane to validates  that the data is shown

SCCM Power BI Dashboard

Power BI Pro

Optional – If you have a Power BI Pro subscription, you can click the Publish button at the top to save your report in your Power BI portal

SCCM Power BI Dashboard

SCCM Power BI Dashboard

SCCM Power BI Dashboard

That’s it! You are now ready to create reports and dashboard using Power BI. Refer to the product documentation if you need help to start creating.

 

 

How to install and configure SCCM Power BI Dashboard
5 - 2 votes

Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 4 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intunes deployments.

5 Comments on “How to install and configure SCCM Power BI Dashboard”

  1. Paul: Try to run PowerBI Desktop as an administrator user. (Right click Power BI Desktop > Run as administrator)
    I know it’s not intuitive, but we experienced the same issue on several machines, and this seems to work.

  2. Hi Benoit,
    Thanks for all your tips!
    Just one question, if I want to reload information from CM Server?

    Thank you!

    Gael

  3. Everything worked until I got to the step where you click “Edit Credentials”. I put in My credentials and clicked connect. When it went back to the Query Editor screen this error was there:
    “DataSource.Error: An error happened while reading data from the provider: ‘Could not load file or assembly ‘System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’ or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542)’
    Details:
    DataSourceKind=SQL
    DataSourcePath=sccm;CM_MON”

    This isn’t a credential issue because I did it again typing in the wrong credentials and it told me that my credentials were incorrect so that tells me that it is authenticating ok but then running into a different issue.

    Any ideas?

    Thanks,

    Paul

Leave a Reply

Your email address will not be published. Required fields are marked *