PowerBI SCCM Dashboard – Installation

Target: Create a simple SCCM Dashboard to view the Update-Compliance and Client-health.

Download the Dashboard from the following Link:


This will guide you through the setup – you need to specify a user which has read access on the CM-Database and a destination SQL-Database / Azure. At the end you need to download the report:


To open the file you need to install the Power BI Desktop which is free:


All you need to do than is to click on Refresh in the main menu. The report can than be published with the team if you have a PowerBI Pro license / 60 day free trial.

In my case everything went smooth – without any error – and the dashboard is realy good to detect if your clients are healhy: