MEMCM/SCCM
Power BI Dashboards

Due to popular demand, our popular SCCM reports have been converted to SCCM Power BI Dashboard. You can now enjoy our most popular reports in Power BI format.

All Dashboards are compatible with SCCM/MEMCM Current Branch (1511+)

Available Product List

Operating System Deployment Power BI Dashboard

Bitlocker Compliance Power BI Dashboard

Client Data Sources Power BI Dashboard

Operating System Deployment

This SCCM Power BI Dashboard gives you detailed information about your current operating system deployment statistics.

Dashboard Features

This content will show up directly in its container.
Deployment statistics on a specific task sequence
Detailed information on success and failed task sequences
How many task sequence has been deployed, per days
Show the deployment average time per task sequence
Sees at which task the task sequence has failed
Quickly identify which computer has completed or failed a task sequence
Help optimize task sequence run time Isolate run time issue based on collections
Easily track your Windows 7 to Windows 10 deployment statistics
Any kind of task sequence is supported (Application, Upgrade, New computers)
Quickly identify which applications are slowing down your deployments
Quickly identify which task is slowing down your deployments

Back to top

Bitlocker Compliance

This SCCM Power BI Dashboard gives you detailed information about your BitLocker compliance statistics.

Dashboard Features

Visually see which device are not compliant to your company policy
Quickly identify with machines are not encrypted using Bitlocker
See Bitlocker volume conversion Status
Identify TPM status (Active/Inactive, Enabled/Disabled, Owned) on your devices
Identify outdated TPM versions
Identify Firmware Boot Type
Identify SecureBoot status
Filter the Dashboard by collections, device type or AD Site Name
List all device Bitlocker compliance per machine in a single table
Export compliance data and share it with your team

Before running this Dashboard, make sure that your Bitlocker inventory classes are enabled. To do so, follow the instruction in the How To Enable Bitlocker Inventory section of the Monitor Bitlocker Status Using Sccm Bitlocker Report post.

Back to top

Client Data Sources

This SCCM Power BI Dashboard gives you detailed information about your client data sources statistics.

Dashboard Features

Identify the downloads location of your SCCM clients
Identify clients that download from Distribution Point, CMG, Branch Cache, DO, Windows Updates
Quickly identify boundary groups configuration mistakes
Identify VPN clients that download data from a internal DP
Evaluate Content Source per Day and per source using a graph
See the top distributed content in your organization
Identify which client use a distribution point and which one uses a peer
Filter Dashboard by: Content Type, Boundary Group, Device Type, Content Source Type...
Doesn't include details about Super Peer sources

This PowerBI dashboard version is not support in PowerBI Report Server latest version (January 2020). For more details, you can read this post.

Back to top

Support

How to install our Power BI Dashboards

Before downloading the Power BI template files, please follow our previous blogpost and install the Power BI Desktop software. Download the latest version from here.

After installation is completed, download one of our dashboards and save it on your computer.

Open the template file, click Cancel if it asks you for the Power BI account or just sign in if you already have an account
Click Ok if there is a version notice message
Click Cancel when the data is loading
In the new window,
- Enter your SCCM Database Server name (ex: SCCM01)
- Enter your Database name (ex: CM_123)
Once all information has been entered, the loading process is starting. It can take between a minute to a couple of minutes depending on the size of your SCCM infrastructure.
Check the following video for a short demonstration:

Publishing Power BI Dashboard Online

You can publish it on your Power BI Server for the internal use only or on the Power BI Service.

For internal use, you can download Power BI Server and start publishing your reports on the internal network. This is a paid product but you can use it free for the first 6 months. You can actually use the same license key if you have SQL Server Enterprise with Software Assurance. Important to know is that Power BI Server will publish only the reports from Power BI Desktop with the same version or less version number. Microsoft is usually releasing the PBI Server and desktop compatible version every 3 months. The latest version at the time writing this blog post is the May version.

You can as well publish reports and dashboards through Power BI Service and make them public for everybody or only for a couple of users. Note that if you would like to publish the reports for specific persons, they will need a paid O365 account or Power BI Premium license.