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.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s