Power BI SCCM configuration Part 1. The Power BI SCCM dashboard provides detailed information of your System Center Configuration Manager including client and server health, malware protection, software updates, and software inventory across your organization. You can compare key System Center Configuration Manager metrics to personalized targets and see how they trend over time. You can also identify trouble spots and get the information you need to understand what needs to be done. Material from blog.

The first page provides a high level overview of key SCCM metrics to quickly identify machines not up-to-date with software updates, failed mitigations to malware infections to be able to act promptly, failed updates and more:

0afa9a90-5617-4ecd-bd45-415c62530369So how to connect Power BI to your SCCM infrastructure. I do this on the SCCM SQL Database Server.

1. Before we start, Download “Power BI Desktop”;

2. After downloading – install it;

sccmpwbipt113. After installation uncheck “Launch Microsoft Power BI Desktop” and click “Finish“;

sccmpwbipt12a4. Go to this site and click “Install now“;

sccmpwbipt135. Read the requirements and click “Download“, “Save” downloaded file and then “Run“;

sccmpwbipt14


6. Click “Install“, when installation completed click “Close“‘

sccmpwbipt167. After installation you can find Power BI file “SCCMSolutionTemplate.pbix” in “C:\Program Files\Microsoft Template\Microsoft-SCCMTemplate\template\Microsoft-SCCMTemplate\service\PowerBI“;

sccmpwbipt178. Copy this file to your desktop and open it;

9. If you go to “Overview” you may see that it’s blank;

sccmpwbipt1810. You need to connect it to your SCCM Database;