Free Power BI Report for Microsoft and Third-Party Updates in Configuration Manager

The Patch My PC Power BI dashboard can monitor the compliance and deployment of third-party and Microsoft security updates through Configuration Manager.

Introduction: (0:00)
Getting started: (0:14)
Opening the PowerBI Template file (.pbit) in the PowerBI Desktop Application: (0:42)
Filling out the prompt in PowerBI: (1:23)
Native Database Query prompts: (2:08)
Waiting for the data to load into the model: (2:43)
Reviewing the Compliance Overview tab: (3:05)
Viewing the Raw Data: (4:40)
Data Relationship Map: (4:55)
Workstation Compliance tab: (5:16)
Server Compliance tab: (6:37)
Refreshing the data in the report: (6:53)
Wrap-up: (7:36)

#PatchMyPC #SCCM #ConfigMgr

[TidyDawg]

This is amazing thank you, I'm trying to build this out utilising your SQL queries, can I ask do you happen to have the PatchCalculations query hosted somewhere please?

[selvapriyan]

Hi, When we import the data to the powerbi will it take more time ? Is it actaully downloading to the local machine ? Is there any requirement for disk space in the PowerBI installed machine or can we install the powerbi in the same server who is running SCCM sql server ?

[wellertm]

How can I limit the resulting devices to exclude Inactive devices?

[Underdoge_]

Can we have something similar for Intune? Thanks!

[hydewhyte]

Unable to open template. This file uses many -to-many relationships or a composite model ....