Tag Archives: Power BI

Standard

Posted by

Posted on

January 25, 2020

Posted under

Power BI

Comments

Leave a comment

Intune Compliance with Power BI

Power BI is a powerful service for data analysis, data visualization, and business intelligence. But how can you take advantage of Power BI and pull data from Microsoft online services like Intune.

There are couple of ways to load data into Power BI from Intune per below. Make sure you are logged into your Power BI app. If you don’t have a license, you can get a 60 day trial.

OData link

  1. One way to connect is using the OData link. You will need a URL to connect to data warehouse.
    1. In the Intune portal, click the Set up Intune Data Warehouse link in the far right of the overview page.
    2. Grab the link from the next page
    3. Open the Power BI Desktop, Choose File -> Get Data to select the OData feed. Enter the URL above in the feed.
    4. Connect using the Organizational Account and signed into your tenant.
    5. Once you are signed in and connected, the tables will load showing you a successful connection.
    6. Follow the instructions on the following link to get started to build your own reports. https://docs.microsoft.com/en-us/intune/developer/reports-proc-create-with-odata

Intune Compliance app

  1. Another way is to use the Intune Compliance app that is in preview here.
    1. Click Get it now.
    2. At the Install this Power BI app, click install.
    3. A Sample data will show but to connect to your Intune tenant, use the Connect your data link.
    4. In the Connect to Intune Compliance and sign in using an account with rights.
  2. You may have to wait about 5+ minutes for the connection, until then you may still see sample data.
  3. You will know when you’re connected to your source when the sample data banner is no longer displayed. You may need to reload the page for the display to refresh.
  4. Once connected, you can click the Intune Compliance (Data Warehouse) in the left Navigation pane.
  5. You have the default Compliance Overview dashboard (example below), reports, and the dataset. You can Save As the existing report and create a custom one or create ones from scratch.