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.

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.

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.

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: