In my previous post we saw the steps to package and deploy Power BI Desktop using SCCM. In this post we will focus on SCCM Power BI dashboard installation and configuration. You can also call this as integrating Power BI with SCCM. Microsoft provides you Power BI solution template for System Center Configuration Manager.
The template is free to download. You can download the SCCM Power BI solution template here. The solution template is scalable and allows you to customize. You can add information about your users and computers and refine data the way you want to.
When you install this Power BI SCCM template, it is so easy to understand your environment at a glance. At the end of this post you get to see the screenshot of SCCM Power BI dashboard. A Power BI SCCM Dashboard provides high level overview of key SCCM metrics. This allows SCCM admins to quickly identify machines that are not patched with updates, failed mitigations to malware infections etc.
Table of Contents
SCCM Power BI Dashboard Prerequisites
- Ensure you have a work email address to sign in to Power BI.
- Power BI SCCM template needs PowerShell v5 and .NET Framework 4.5.2 to be installed on machine.
- System Center 2012 Configuration Manager R2 SP1 or later is required.
- To access SCCM data you need a user account with read access to the SCCM DB.
- The machine where you install Power BI desktop should have IE version 9 or later. Also the machine should have .NET framework 4.5 installed.
- You need either Azure SQL database or SQL Server database (SQL Server 2008 R2 SP3 or later).
SCCM Power BI Dashboard Installation and Configuration
Lets start SCCM Power BI dashboard installation and configuration. To download the SCCM Power BI template, read the below update.
Update – The template download link was down since many months. Finally I got the update from Power BI team about the download. The SCCM Power BI solution template download has been moved to GITHub and you can download the template by clicking this link. Navigate to Apps > Microsoft > Released > Microsoft-SCCMTemplate > Service > PowerBI. You will find two templates. Download the one that you require.
Click Get it Now and sign-in with your work account. On the Getting Started page, click Download. This will download system center configuration manager solution template on to your machine.
Run the Microsoft-SCCM template executable and on setup screen, click Install.
The installation is complete. Click Restart button.
SCCM Power BI Configuration
After the reboot, login to the machine and launch the Microsoft-SCCMTemplate application. This will bring you back to Getting Started page. Click Next.
On the Login page, specify your windows credentials to create a recurring schedule. The same credentials will be used to connect to SCCM DB as well. Click Validate and once the validation is successful, click Next.
This step is for connection Power BI to SCCM. On the Source page, specify windows credentials to connect to SCCM database. Click Validate and upon successful validation click Next.
On the Target page, specify the credentials to connect to your SQL database. Validate and click Next.
Most of all you can specify email address to get the updates related to Power BI. You also get a deployment completion email to email address that you supply. Click Run to build the solution template.
After all the steps are complete, click Download Report. Save this template on your computer.
SCCM Power BI Dashboard Configuration
Launch the Power BI desktop and click File > Open and select the solution template. Once you open the solution template, you see something like shown in below screenshot. We need to configure few things, therefore DO NOT click Apply Changes at this step.
On the menu bar, click Edit Queries and then click Edit Queries. Notice on the left pane, you see exclamation icon under Queries. On the Query Editor window, click Edit Credentials. You can specify alternate credentials to access SCCM database. Finally click Connect.
If the credentials entered are correct, you will notice that exclamation symbol is gone. You also see site code, site name, version etc. Click Close and Apply to apply the changes that you just did.
Click on Overview tab at the bottom and you will now see dashboard. The below dashboard shows the information about clients and users that are part of my lab setup. When you install and configure this on your production setup, you would find more information about your SCCM infrastructure. If i get time I will update this post with screenshots of dashboards configured for my organization.