How to Install and Configure Configuration Manager Power BI Dashboard

How to Install and Configure Configuration Manager Power BI Dashboard. The Configuration Manager Power BI Dashboard provides detailed information on the Configuration Manager hierarchy including client and server health, malware protection, software updates, and software inventory.

Configuration Manager Power BI Dashboard Prerequisites

• 系统中心 2012 Configuration Manager R2 SP1 (5.00.8239.1000) or later. Read access to the Configuration Manager database is required.
• Destination database: 天蓝色 SQL database or SQL Server database (SQL服务器 2008 R2 SP3 or later).
• Valid Work email address (Power BI Desktop sign-in).
• PowerBI Desktop app.
• PowerBI Pro license (if you want to share your reports)
• For the machine where the installation is run:
  • 微软 .网络框架 4.5 or later.
  • PowerShell version 5.0 or later.
  • For Operating System: Windows服务器 2008 R2 SP1, or later. 视窗 7 Professional, 企业, or later.

Power BI Desktop Installation

We will start by installing Power BI Desktop:

• Download Power BI Desktop from the Microsoft download center;
• Execute PBIDesktop_x64.msi, 点击 下一个;

• Accept the license terms and click 下一个;

• Select the Installation Directory and click 下一个;

• 点击 安装;

• When the process finishes, 点击 结束 to close the installation wizard;

Power BI Integration

The SCCM Power BI solution template download has been moved to GitHub. Download and run Microsoft-SCCMTemplate.exe.

• Wait for the process to complete

• 这 installation wizard will launch in a new window Get Started with System Center Configuration Manager. You can Close the SCCM Template installation. 单击下一步;

• On the Login page, Enter your credentials to connect to the SCCM database. These credentials will also be used to run a Powershell script on a recurring schedule. Click on Validate, then Next;

• In the Source pane, enter your SCCM server name, click on Validate, select your Database from the drop-down then Next;

• On the Target pane, select your SQL服务器, click on Validate, select your Database from the drop-down then Next;

• If you are using Azure SQL (which is unlikely for an SCCM installation), check the Using Azure SQL box;

• Some steps will be automatically skipped (Because we don’t use Azure SQL);
• On the Customize pane, select the time you wish to have your scheduled task to be run and the desired Compliance Target number, click on Validate and Next;

• Review your choices, enter your email address if desired to receive information about Power BI and click Run;

• The installation starts. The initial synchronization pulls data out of the Configuration Manager database and pushes the data into the specified early SQL Database;

• Once the process is completed, you can download the pre-configured Power BI SCCM Dashboard by clicking on Download Report;

• Once downloaded, open the SolutionTemplate.pbix file, it will open in Power BI Desktop. On the top ribbon, click on Edit Query and select Edit Wueries;

• Click on any query on the left pane and select Edit Credentials;

• Select your preferred credential method and click Connect;
• If you have an Encryption Support warning, click OK to accept the unencrypted connection

笔记: If your credential has the Read right on the SCCM database, all the “!” icons will turn into table icons. This means that the data can be read.

• Click the Apply Changes button on the warning on the top;

• Click the Overview pane to validate that the data is shown;