Connect to the Data Warehouse with Power BI

Applies to: Intune in the Azure portal
Looking for documentation about Intune in the classic portal? Go here.

You can download a file for use with Microsoft Power BI that allows you to load interactive, dynamically generated reports for your Intune tenant. The Data Warehouse Power BI file (pbix) contains connection settings to your tenant, and the following sample reports and charts:

  • Devices
  • Enrollment
  • App protection policy
  • Compliance policy
  • Device configuration profiles
  • Software updates
  • Device inventory logs

There are also trends highlighted for the enrollment, compliance, device configuration profile, and software updates. Sample charts and reports apply user-friendly filters to the canvas. To use advanced filters, check out the Filter pane in Power BI Desktop.

The following steps show you how to download the Power BI file and how to use the OData link with Power BI.

Azure AD and Intune credential requirements

Authentication and authorization are based on Azure AD credentials and Intune role-based access control (RBAC). All global administrators and Intune service administrators for your tenant have access to the Data warehouse by default. Use Intune roles to provide access for more users by giving them access to the Reporting resource.

Requirements for accessing the Intune Data Warehouse (including the API) are:

  • Intune license must be assigned to the user
  • User must be one of:
    • Azure AD global administrator
    • An Intune service administrator
    • User with role-based access to Reports resource

Install Power BI

Install the latest version of Power BI Desktop. You can download Power BI Desktop from: PowerBI.microsoft.com

Load the data and reports using the Power BI file (pbix)

The Power BI file (pbix) contains connection information for your tenant and a set of prebuilt reports based on the Data Warehouse data model. Open the file in Power BI Desktop and sign in to the Azure AD. The report loads the data from your Intune tenant.

Important

Each Power BI file (pbix) may be different depending on tenant location. If you are managing multiple Intune tenants, then be sure to use the file downloaded from the Azure portal while logged in to that tenant.

  1. Sign in to the Azure portal and choose Monitoring + Management > Intune. You can also search resources for Intune.
  2. Open the Microsoft Intune Data Warehouse API (Preview) blade.
  3. Select Download PowerBI file. The file with a (pbix) extension downloads to the location you specified.
  4. Open the file with Power BI. The Intune Data Warehouse Reports loads, but may take a second to get your tenant data.
  5. Select Refresh to load your tenant data and review the reports.
  6. If Power BI has not authenticated with your Azure Active Directory credentials, Power BI prompts you to provide your credentials. When selecting your credentials, choose Organizational account as your authentication method.

With a client authenticated to Azure AD, the OData URL connects to the RESTful endpoint in the Data Warehouse API that exposes the data model to your reporting client. Follow these instructions to use Power BI Desktop to connect and create your own reports. You are not limited to Power BI Desktop, but can use your favorite analytic tool with the OData URL provided the client supports OAUTH2.0 authentication and the OData v4.0 standard.

  1. Sign in to the Azure portal and choose Monitoring + Management > Intune. You can also search resources for Intune.
  2. Open the Microsoft Intune Data Warehouse API (Preview) blade.
  3. Retrieve the custom feed URL from the reporting blade, for example https://fef.{yourinfo}.manage.microsoft.com/ReportingService/DataWarehouseFEService/dates?api-version=beta
  4. Open Power BI Desktop.
  5. Choose Home > Get Data. Select OData feed.
  6. Choose Basic.
  7. Type or paste the OData URL into the URL box.
  8. Select OK.
  9. If you have not authenticated to Azure AD for your tenant from the Power BI desktop client, type your credentials. To gain access to your data, you must authorize with Azure Active Directory (Azure AD) using OAuth 2.0.
    1. Select Organizational account.
    2. Type your username and password.
    3. Select Sign In.
    4. Select Connect.
  10. Select Load.

Next steps

You can find the answers to questions about your environment such as the number of devices enrolled by day over the last week. You can gain insight into your Intune tenant and client population using the reports using the Intune Data Warehouse Power BI file (pbix) retrieved from the blade in Azure. However, Intune provides a number of additional ways to extend or reuse the data. There is a lot more that you can do with Power BI and the Intune Data Warehouse API, for example: