Power BI : Power BI SCCM Template from Microsoft


This post runs through the process of setting up Power BI and the SCCM template which will give you detailed information on your System Center Configuration Manager including client and server health, malware protection, software updates, and software inventory across your organisation.

First things first, to run the Power BI SCCM template you need to running PowerShell v5 on the device that you install it on.

Run a Get-Host on your device to see the PowerShell version installed.

2017-03-20 17_15_42-Administrator_ Windows PowerShell.jpg

If it’s not v5 then go to here and grab a copy and install.

Download the SCCM Template

Next head over to https://powerbi.microsoft.com/en-us/solution-templates/sccm/

Click ‘Install Now’ to start the installation of the Power BI SCCM template.

2017-03-20 16_41_30-Solution templates _ Microsoft Power BI ‎- Microsoft Edge.jpg

Scroll down and click ‘Sign In’

2017-03-20 16_41_44-Getting Started ‎- Microsoft Edge.jpg

Once you have signed in you will need to allow access to the Business Platform Solution Template. Click Accept to do this.

2017-03-20 16_42_00-Authorise Business Platform Solution Template ‎- Microsoft Edge.jpg

You’ll now be presented with a Download button.

2017-03-20 16_42_21-Getting Started ‎- Microsoft Edge.jpg

Install and configure the Microsoft-SCCMTemplate

Run the downloaded file ‘Microsoft-SCCMTemplate.exe’. Click Install.

2017-03-20 17_17_58-Microsoft-SCCMTemplate Setup.jpg

2017-03-20 17_18_05-Microsoft-SCCMTemplate Setup.jpg

Restart the device once setup is complete.

2017-03-20 17_24_03-Microsoft-SCCMTemplate Setup.jpg

Once the machine is back up and running you need to execute the ‘Microsoft-SCCMTemplate’ application.

2017-03-20 17_26_23-Greenshot.jpg

At the wizard click ‘Next’

2017-03-20 17_26_44-Solution Template Installer.jpg

Enter credentials that will be used to connect to the Configmgr DB and click ‘Validate’

2017-03-20 17_27_01-Solution Template Installer.jpg

Click ‘Next’ when validation is successful.

2017-03-20 17_27_43-Solution Template Installer.jpg

Now enter the name of the server hosting your site database and click ‘Validate’. Once validated successfully click Next.

2017-03-20 17_28_02-Solution Template Installer.jpg

Now we need to specify a server running SQL server to use as a target. I have installed a server called ConfigMgr2 one which SQL is installed. I have also created a database called PowerBI which I will use to host the data. Enter the server name, click Validate and the choose the correct DB from the drop down list. Click Next to continue.

2017-03-20 17_33_13-Solution Template Installer.jpg

Enter the relevant details for trigger time or compliancy and click Validate then click Next.

2017-03-20 17_33_42-Solution Template Installer.jpg

Click ‘Run’ to build the solution template.

2017-03-20 17_33_47-Solution Template Installer.jpg

This process can take a little while so grab a cuppa.

2017-03-20 17_35_48-Solution Template Installer.jpg

Until it has completed. Then click ‘Download Report’

2017-03-20 17_49_13-Solution Template Installer.jpg

Save the .pbix file.

2017-03-20 17_37_29-Save File.jpg

Install Power BI Desktop

Go to https://powerbi.microsoft.com/en-us/desktop/ and download the Power BI Desktop.

2017-03-20 23_48_23-Power BI Desktop _ Microsoft Power BI ‎- Microsoft Edge.jpg

Run the PBIDesktop_x64.msi on a desktop OS. Click Next.

2017-03-20 17_40_15-Microsoft Power BI Desktop (x64) Setup.jpg

Accept the licence agreement and click Next.

2017-03-20 17_40_20-Microsoft Power BI Desktop (x64) Setup.jpg

Enter a location to install and click Next.

2017-03-20 17_40_23-Microsoft Power BI Desktop (x64) Setup.jpg

Click Install and Finish to complete.

2017-03-20 17_40_26-Microsoft Power BI Desktop (x64) Setup.jpg

2017-03-20 17_40_34-Microsoft Power BI Desktop (x64) Setup.jpg

Configure Power BI Desktop to use the SCCM Template file

Launch the Power BI Desktop and open the Solution Template file saved earlier.

In the ribbon click the Edit Queries button and choose ‘Edit Queries’.

2017-03-20 22_48_44-Greenshot.jpg

Highlight one of the nodes in the left hand nav with a warning triangle, I have chosen ‘Site’, and click ‘Edit Credentials’.

2017-03-20 22_49_22-SolutionTemplate - Query Editor.jpg

I’m using the current credentials as these will have access to the PowerBi database. Click Connect.

2017-03-20 22_49_29-.jpg

Click OK

2017-03-20 22_49_37-.jpg

The warning triangles will disappear from the left hand hav as the query connections are made successfully.

2017-03-20 22_49_50-SolutionTemplate - Query Editor.jpg

Close the query editor and select the ‘Overview’ tab from the main screen. If the dashboard comes back as BLANK then hit refresh in the Ribbon bar.

2017-03-20 22_50_47-.jpg

Once refreshed the dashboard should populate with data with some pretty cool info straight out of the box.

2017-03-20 22_52_19-SolutionTemplate - Power BI Desktop.jpg

2017-03-21 00_17_34-SolutionTemplate - Power BI Desktop.jpg




Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s