Announcing PowerON BI ConfigMgr Dashboard 1611

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 a tested version based on a ConfigMgr or BI release.

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

Written by


01 Apr 2018

Version 1611 Release Notes

  • Tested with November 2016 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 CM 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

ConfigMgr 1611 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.



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.ConfigMgr 1611 

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 useful for keeping on top of updates.  Site Admin 

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. Once installed Open Power BI. 1. Go to File > Options and Settings > Options. 2. Under Privacy enable Fast Combine to file privacy.Privacy Levels 3. Under Security untick “Require user approval for native SQL database queries”. Native Queries 4.  Select Edit Queries to load the Query Editor. Edit Queries 5. Supply parameter information in the Setup section Setup  6. Select the “_Client Information” query under the ConfigMgr and supply any credentials required to access the database. Credentials 7. If prompted, Click OK on the encryption support message. Encryption 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. SCCM Demo Dashboard                      The great thing about publishing is you can utilise the ask a question feature which is awesome!  

                              Natural Query

 Power Bi also comes with a mobile app which allows you to access the report from your mobile device anywhere too. Mobile Dashboard  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

Share on Facebook
Share on Twitter
Share on LinkedIn

Related blogs

two people at desk looking at code

AOVPN DPC V4.0 is Now Live!

Today we’re very excited to announce the release of AOVPN DPC 4.0 with support for Windows 11! AOVPN Dynamic Profile Configurator is now functional with