Announcing PowerON BI ConfigMgr Dashboard 1611

The next installment of the Power BI Configuration Manager Dashboard is here!

We’ve been busy making some changes to the successful 1.4 version which we brought out back in July. We’re now over 4000 downloads on the technet gallery and can’t believe the positive response from the community.

With the ever progressing Power BI (BI) and Configuration Manager (ConfigMgr) updates, we had to address a few problems with query and website changes. I took the decision to wait for this version rather than release a quick fix as we were so far into this one and wanted to get this version out asap.

With this version, we’ve taken the approach to change naming convention in line with ConfigMgr, moving to a Year/Month format. This should make it easier when BI and ConfigMgr receive updates, as we can release tested version based on a ConfigMgr or BI release.

I hope you’ll enjoy the update and the improvements we’ve made to it 🙂

Version 1611 Release Notes

  • Tested with November Power BI desktop update
  • Workstation Admin Breakdown consolidated to one page.
  • Site Admin Page Redesign.
  • Ability to drill down through deployed OS support lifecycle added
  • Windows 10 Breakdown page added (Tested on 1602 and above)
  • Minor visual changes to page layouts.
  • Managed Mobile Devices page updated to include information table.
  • Chassis Type table changed to custom table.
  • Client version web query fixed after table column was changed. 
  • Support Life Cycle query fixed after MS changes. Now changed to api call and updated some of the naming conventions. 
  • SCCM Technet blog feed added.
  • DB Fragmentation page visual updated to include min/max on saturation and URL link added.

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 now built into the report and workstation admin page consolidated into main page.

*New* Windows 10 Breakdown

This contains a breakdown of your Windows 10 workstations including things like branch and OS version.

Client Health Summary
Contains summary information on your clients health and activity status.
Update Compliance

This view contains 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.
*New* Site Admin
The site admin view has been completely revamped. With changes to the support lifecycle page, it stopped the query from pulling back information. We’ve updated this to now include a drill down for Mainstream, Extended and Service Pack end dates. We’ve also included the technet blog feed and site information to really made this page usefl for keeping on top of updates.
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. We’ve updated the visuals and included a table view for additional information.
DB Fragmentation 
DB Fragmentation Report into the dashboard. SQL query from Kent Agerlund’s NIC 4th Edition. Updated saturation visual to highlight on min/max value.

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 lastest Power BI desktop here.
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 untick “Require user approval for native SQL database queries”.
4.  Select Edit Queries to load the Query Editor.
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!


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

Leave a Reply

Your email address will not be published. Required fields are marked *