Call us:+1 (407) 567-0096
Open a ticket
Chat with us
En De Es

Blog

This website uses cookies

This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with our Cookie Policy.
Read more
Back

Implementing SCCM Power BI Dashboard

Day by day Microsoft Power BI getting the popularity of the business intelligent world as a data analytic tool with its interactive visualization capabilities. It can connect with multiple different systems, applications and data sources to transform the data into stunning visualization which you can visually explore and analyze data on-premises and in the cloud, all in a single view.

Using SCCM Power BI Template you can connect your SCCM Infrastructure with Power BI and enjoy its rich interactive visualization dashboard. From this post lets discuss how we implement the SCCM dashboard with Power BI.

Prerequisites - Download and install Power BI Desktop

Power BI Desktop is a free version which you can download while providing your live account details. You can use this to configure the SCCM Template, but its limit sharing capabilities. To share the dashboard with other people you need to buy the licenses.

  • Use the following link to download

    https://www.microsoft.com/en-us/download/details.aspx?id=45331

  • Run the installation wizard


  • After completing the installation register yourself to the Power BI free version.
  • Before installing the Power BI SCCM Template your installation machine should be running PowerShell version 5. You can check that by running get-host in PowerShell

 

Download and Install Power BI SCCM Template

 

  1. Navigate to the following URL to download the template

    https://powerbi.microsoft.com/en-us/solution-templates/sccm/



  2. Provide your Microsoft Identity and Download the template


  3. Install the downloaded template


 

Configuring the Template with SCCM Infrastructure

 

  1. After completing the installation configuration wizard will pop up. Click Next


  2. Next, provide the SCCM Admin credentials which is having the SQL Database access


  3. Provide the SCCM server FQDN and validate the access


  4. Select the SCCM Server Database from the drop-down box and click Next








  5. After the installation successfully completed, click the Download button to download the file.