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: