Announcing Power BI ConfigMgr Dashboard (1.4)

It’s been a busy couple of months for us on the Power BI front. Following the success of my Power BI SCCM Dashboard (see previous post), I’m pleased to announce version 1.4! This version is a little different though as its the first version with the PowerON brand and its packed with improvements for the community to use.

It’s been a natural progression with the dashboard and with the great things we’re doing at PowerON on the BI front, we felt it was the right time to improve the dashboard and showcase some of the innovate things we’ve implemented in other system center reports.

With this now coming under the PowerON brand, we’re also adding the option to contact PowerON for more advanced consultancy, customisation and enablement support contracts of the dashboard.

Hopefully you’ll enjoy the update and we’ll be continuing to add improvements over the coming months 🙂

Written by

Raf Delgado

Raf Delgado

Product Lead


07 July 2017

Version 1.4 Dashboard Release Notes

  • Complete report redesign
  • Functions for invoking removed following June Power BI update
  • Parameters added for specifying ConfigMgr Server/DB
  • Optional parameters added for limiting collections
  • Optional parameter added for including device name in report
  • Query improvements / bug fixes
Client Overview

This view contains a basic overview of client information such as, EndPoint Compliance, Client Activity and Health.

Workstation / Server Breakdown

This contains a breakdown of your site workstations/Servers including manufacturer, operating systems, architecture and even chassis type info! The Chassis Type information goes off to a technet page so you may need internet access when initially loading your data.

Workstation Admin

This contains a breakdown of your site workstations admin info additional to the workstation breakdown.

Client Health Summary
Contains summary information on your clients health and activity status.
Update Compliance
This view consists of a breakdown for update compliance, showing you missing updates by bulletin ID.
 EndPoint Compliance
This view contains summary information on client EndPoint compliance and protection status.
 Site Admin
The site admin view queries the ConfigMgr dogs TechNet post for the latest SCCM release. It also queries the Microsoft support life cycle site and checks for expired or expiring operating systems currently deployed which you will need to address.
Managed Mobile Devices
This view contains summary information on Managed Mobile Devices in ConfigMgr. It allows you to view things like Make and OS version of devices connected.
DB Fragmentation 
Added DB Fragmentation Report into the dashboard. SQL query from Kent Agerlund’s NIC 4th Edition.


You can download the dashboard from the TechNet Gallery.
 Ensure you have at least read access to the SCCM SQL Database and you can access the Internet from the machine running Power BI.
Download the latest Power BI desktop.
Once installed Open Power BI.
1. Go to File > Options and Settings > Options.
2. Under Privacy enable Fast Combine to file privacy.
3. Under Security uncheck “Require user approval for native SQL database queries”.
native database queries
4.  Select Edit Queries to load the Query Editor.
edit queries
5. Supply parameter information in the Setup section
6. Select the “_Client Information” query under the ConfigMgr and supply any credentials required to access the database.
7. If prompted, Click OK on the encryption support message.
8. Close the Query Editor and load the data

Publishing to the Web

The desktop version of Power BI is free to use and I used this without publishing the report up to the web just to produce a quick report. The data is on this report is not live as its only from the last time you load the data but you can easily reload the information on startup.
For an even better experience, you can publish the file up to the web and create a dashboard.  though there can be cost implications but there is a free version.  Check on Power BI’s website for further information on what best suits you.
The great thing about publishing is you can utilise the ask a question feature which is awesome!

                              natural language

Power Bi also comes with a mobile app which allows you to access the report from your mobile device anywhere too.
Mobile App
For advanced support, customisations or consultancy contact the PowerON team!

Keep Up To Date - Join The Mailing List

The team are here to help

If there are any questions and want to learn more about PowerON’s services or Solutions, please get in touch and a member of the team will be in touch shortly. 

  • PowerON, Stanley Harrison House, York, YO23 1DE
  • 0800 3029280

Contact PowerON

Leave a Reply