Microsoft Entra Suite Tech Accelerator
Aug 14 2024, 07:00 AM - 09:30 AM (PDT)
Microsoft Tech Community
Ignite Keynote Demo Recap: Power BI in SCCM
Published Sep 08 2018 06:33 AM 741 Views
Iron Contributor
First published on CloudBlogs on May 04, 2015
We ran out of time to show this one during the keynote – but you should really check it out:

What’s new:

This demo combined two great things that are long overdue being paired together: Power BI and System Center Configuration Manager. To do this, we used the real data from the Microsoft deployment of SCCM, SCEP, and Intune where we are managing 100,000’s of PCs and 10,000’s of mobile devices. This combination gives IT Pros the ability to monitor and report on software update and endpoint protection compliance in their organization. This is the dashboard every CISO in the world would want to have and use. In a single place you can now get a view of mobile device compliance with corporate policies, PC compliance with security updates, and malware encounters across the entire enterprise. The Power BI dashboard enables you to drill into a wide variety of reports to identify trends and correlations, as well as use the Power BI Q&A feature to quickly identify any user data that may be at risk. [Drops mic]

How this helps:

Sure, this data has always been available in SCCM, but, up until now, it was hidden in database tables and reports. By integrating with Power BI, we are able to make this data accessible and consumable by IT organizations everywhere and enable IT Pros to unlock powerful new ways to work with, learn from, and take action on their data. This is an incredible example of the truly vast benefits of using an integrated solution for PC and mobile device management.

Why you need this in your life:

  • This dashboard is massively helpful for monitoring and reporting on software updates and endpoint protection compliance for your organization.
  • The interface allows you to identify correlations and gain insight into management and security trends.
  • With the Power BI Q&A feature you can immediately get answers to natural language questions about software updates and malware data.
  • Now you can wallow in the data and see insights that would have been impossible to spot before.

What you’ll need to get started:

  • System Center 2012 R2 Configuration Manager SP1
  • Microsoft Intune
  • Microsoft Power BI
  • Critically important: Read the “Getting started with System Center and Power BI” blog post and download the sample spreadsheet .
    • This can run against any System Center 2012 Configuration Manager site.
    • It also includes some of the key reports we have found useful inside of Microsoft.
    • Next step: The real magic will happen, however, when you start to experiment and customize the reports for your own business needs.

Get to work!

To read the recaps for the other ten demos, visit .

Version history
Last update:
‎Sep 08 2018 06:33 AM
Updated by: