Power BI for Microsoft Intune

I have got  my standalone Intune setup with few devices enrolled . In this post, i will go through the reporting feature using  using Power BI to connect to Intune to load data and generate reports dynamically.

These reports will help us to analyse the users who are enrolling the devices for license purchases ,to see the OS manufactures ,compliance status ,updates etc.

Before we proceed further ,first download the Power BI Desktop using link https://powerbi.microsoft.com/en-us/downloads/

image

Power BI Desktop file is about 140MB ,once it is downloaded ,run the setup file with default options.

image

Start the Power BI

image

Click on Get Data

image

 

image

 

image

To get odata feed URL ,you need to login to https://portal.azure.com and search for Intune ,click on Intune ,you will find Intune data Warehouse on the right-side ,click on it

image

Copy the Tenant URL under use third-party reporting services

SNAGHTML27a9563a

while you are on this page ,download the power BI file (intune data warehouse) which has basic set of custom reports to get started https://github.com/Microsoft/Intune-Data-Warehouse/blob/master/Samples/PowerBI/Intune%20Data%20Warehouse%20Report%20(AMSUC0301).pbix?raw=true (this URL is from above link ,might change)

Put the URL into Power BI Odata URL and click Ok

image

It will load with few options to select the level to apply these settings ,i choose the default one that it load automatically

SNAGHTML27afbff4

Click on connect

SNAGHTML27b38b6d

If it ask for authentication ,go to Organizational account and click on sign in.

The user account that you try to login must have power BI license which can be assigned to your user account in Azure portal .

image

 

image

Once you login ,you will see page below and click on connect

image

 

From the navigator, select the options that you be interested to see the data for and click on load . Please be sure the fields that you want. If you choose all tables ,it might take longer to get the data loaded into the file.

SNAGHTML2803d089

 

image

For me ,it took approximately 2 min to load the data (i have only few devices enrolled).

We have now the data loaded and we should be able to generate the reports dynamically however we want.

image

Now ,lets try to download the some sample power BI (pbix)  files and load into the power BI using https://github.com/Microsoft/Intune-Data-Warehouse/blob/master/Samples/PowerBI/Intune%20Data%20Warehouse%20Report%20(AMSUC0301).pbix?raw=true

Go to file and open report that you downloaded using above URL.

Once you are imported ,click on apply changes to load your intune data into the imported power BI file  which takes time to load all the tables .

SNAGHTML280e3aef

I have few error while loading the data and that is related to memory (less RAM) due to resource constraint ,but after closing other applications ,i can successfully import the data.

SNAGHTML28216624image

 

Once the data is loaded fully ,You can click on the pie charts to know its data .

you will see different tabs at the bottom of power BI tool like Devices,Enrollment,App protection policy,Compliance policy,Device configuration profiles,Software updates,Device inventory logs.

These tabs comes from the file that we imported. You can also created/customize pie charts and save the file as  pbix file which can be shared to others.

For each tab have filters which can be changed depends on the requirements like i want to know the devices that are enrolled between specific dates ,last contacted date and based on manufacturer etc.

All these filters can be applied in each tab in this report.

 

References

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-get-started/

https://docs.microsoft.com/en-us/intune/reports-proc-get-a-link-powerbi

Leave a Reply