Automating Intune reports through Power BI

Applies to: Microsoft Intune

Introduction


Power BI Desktop lets you build advanced queries, models, and reports that visualize data. Power BI Desktop enables you to build data models, create reports, and share your work by publishing to the Power BI service. This article describes how you can automate Intune reports through Power BI.

How to automate Intune reports


To automate Intune reports through Power BI, follow these steps.

  1. Sign up at or log on to Power BI

    To share Power BI information with other users, you first must set up an account. Many organizations already have access to Power BI. If you're new to the service, you can set up a free personal account to get started (see Signing up for Power BI as an individual). If you don't know whether you have an account, log on to https://www.powerbi.com by using your corporate identity to see whether a Power BI account is available to you.

  2. Download Microsoft Power BI Desktop

    After you have a Power BI account established, download and install Power BI Desktop. This is the main tool that you use to access Intune Data Warehouse data.

  3. Download and open the Power BI .pbix file

    1. Sign in to the Azure portal, and select 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 that has a .pbix extension downloads to the location that you specify.
    4. Open the file by using Power BI. The "Intune Data Warehouse Reports" file loads but may take a moment to gather your tenant data.
    5. Select Refresh to load your tenant data and review the reports.
    6. If Power BI does not authenticate by using your Azure Active Directory credentials, it prompts you to provide your credentials. When you do this, select Organizational account as your authentication method.
       
  4. Publish the workbook

    After you successfully load your tenant data in Power BI Desktop, you can publish it to the Power BI service to share with other users. Click Publish in Power BI Desktop, and follow the prompts to select a location for uploading the Intune data. If you don't have another location to use, you can select My workspace.

    Publish to Power BI


    Power BI Desktop uploads the data and publishes the .pbix file for you.

    Publishing to Power BI


    Publishing to Power BI
  5. Set up a scheduled refresh.


    Follow the steps in the How to configure Power BI report scheduled refresh topic on the Microsoft Docs website to publish your data and set up an automatic refresh.

    To verify your settings, click the Settings icon (the gear icon in the upper-right corner of the Power BI dashboard).

    Power BI Settings

    Important settings to check

    • Data source credentials: Verify that the settings for OData specify an account that has rights to query the Intune Data Warehouse. The authentication type should be OATH2.
    • Scheduled refresh: Verify that Keep your data up to date is set to On.
    • If your password changes, you must remember to update this setting in Power BI.
       
  6. Create a subscription

    Follow these steps to automatically receive a copy of the reports daily in email:

    1. Connect to https://www.powerbi.com, and then log on.
    2. Locate your workspace, and then click Reports.
    3. Select Intune Data Warehouse Report (filename).

      Power BI My Workspace

       
    4. Click the Subscribe envelope icon.

      Intune Data Warehouse Report

       
    5. Enter your subscription details.

      Subscribe to emails

       

    There are several settings to examine here:

    • You can add email aliases within your organization in the Subscribe field.
    • The default frequency is Daily. Because the warehouse is updated daily only, this setting is sufficient for this subscription.
    • Each tab in Power BI (Devices, Enrollment, and so on) requires its own subscription. If you want to combine multiple reports into a single document, you must create a custom report. When the subscription updates, you will receive an automated email message that includes a copy of your report.

      Microsoft Power BI (No Reply)

More information


  • Data is updated once daily only. Data Warehouse information should be used for spotting trends and general management of a business. If you must have live data, the Azure portal and Graph APIs provide near-real-time data.
  • Reports can be sent multiple times during the day. However, they will contain identical data until the daily update occurs.
  • Sharing data requires a Power BI account. Without uploading data to Power BI, the .pbix files can be shared locally.
  • Datasets, OAuth credentials, and Power BI Gateway credentials must be manually updated if a password is changed.
  • Power BI Support owns the publishing, setup, Power BI subscriptions, and other processes. If you can successfully download the .pbix file from the Intune portal, that is the extent of our support for Power BI.
  • This article exists as a how-to and general set of steps. It is not meant to be all-inclusive. There are many other possible configurations.