Power BI with SCCM

Integrate Power Bi with SCCM

With sccm, it is possible to use reports natively using SQL reporting. If you want more advanced reports, more ergonomic, … It is possible to integrate Power BI with SCCM. This way you will be able to use all the power of Power Bi with SCCM.

Prerequisites

For integrate Power BI with SCCM, some prerequisites are necessary.

  • System Center 2012 R2 SP1
  • PowerShell v5 and .NET Framework 4.5.2 for Power BI SCCM
  • Windows Server 2008 R2 SP1, or later. Windows 7 Professional, Enterprise, or later
  • User account with read access on SCCM database
  • Azure SQL or SQL Server for destination database
  • Valid work email address
  • Machine with PowerBI Desktop installed.

Install Power BI Desktop

Click on the link for download Power BI Desktop. I installed Power Bi desktop on the SCCM server but it can be installed on another machine. When download is finished, run setup.exe file.

Integrate Power BI with SCCM - Run setup file

A wizard appear, select language and click on Next.

Integrate Power BI with SCCM - Wizard appear

Accept the license terms and click on Next.

Integrate Power BI with SCCM - Accept terms of licence

Select the destination folder. You can leave the default choice or change folder with Change button.

Integrate Power BI with SCCM - Select destination folder

Click on Install for begin Install step.

Integrate Power BI with SCCM - begin installation

Click on Finish when it’s finished.

Integrate Power BI with SCCM - installation is finished

Power BI Integration

It is now time to proceed with the integration of Power BI with SCCM. From the Github PowerBI repo, click on Microsoft-SCCMTemplate.exe.

Integrate Power BI with SCCM - Download SCCM template

Click on Download for download the file.

Integrate Power BI with SCCM - Download SCCM template

Run the previous downloaded file. A new windows appear, click on Install.

Integrate Power BI with SCCM - Download SCCM template

When installation is finished, a new windows appear. Click on Next.

Integrate Power BI with SCCM - Download SCCM template

I choose to use my admin SQL Server but you can use a user with read-only rights. Enter the password and click on Validate. If user and password has successfully validated, you can click on Next.

Use account for connect to SQL Server

Enter the name of SCCM Server and click on Validate. Select the Configuration Manager database and click on Next.

Connect SQL Database to Power BI

Enter the name of SQL Server and choose the type of authentification (SQL Server or Windows). CLick on Validate.

Connect SQL Database to Power BI

Select the Configuration Manager database and click on Next.

Connect SQL Database to Power BI

Configure the Customize option and click on Validate. If the parameter has successfully validated, click on Next.

Customize option for Power BI

Click on Run for begin configuration.

Run configuration

When all the steps are complete, click on Download Report and save it on the computer/server.

Download power bi report

Open Power BI Desktop and click on Try free if don’t have account for Power BI Pro.

Open Power BI Desktop

A web page appear, enter valid work email. Follow the different steps for registration

Connect with work mail

After registration is complete, you can open Power BI Desktop and click on Sign in. Log in with the work email address. From Power BI desktop click on File, Open then on Browse.

Open templates on PowerBi

Select the previously template and click on Open.

Open templates on PowerBi

Click on Apply changes from the Power BI console.

Apply changes

Choose the desired credential and click on Connect. Click OK on Encryption Windows support.

Select credential for PowerBI

Apply query changes is in progress.

Connect to database

If credential is correct, table present on SQL Database appear on the fields.

Table SQL Appear

Some reports are already available but you create your own reports

Create power bi report

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.