Skip to content

Configure Intune Export API

Microsoft have migrated some of the data that BI for Intune uses to the new Intune Export API. Each region in which Microsoft host Intune has a unique download URL that is sent as a response to queries made against this API. For this reason we have introduced new dataset parameters that should be configured for this data be imported into Power BI. Configuring these parameters are not mandatory, however if you do not configure these parameters as described here BI for Intune will make a call to a redirect API owned by Fatstacks. The purpose of the redirect API is to automate locating the correct download URL for your Intune tenant and pass that URL back to BI for Intune to download content from the Export API to Power BI. No protected data is passed through Fatstacks if you leverage the redirect API. However, we recommend that customers follow this guide to bypass using our redirect API altogether.

Step 1: Open Windows Updates report

  1. In the Intune console select the Reports pane.
  2. Select Windows Updates (preview).

Step 2: Open Feature Update report

  1. Select the Reports tab.
  2. Select the Windows Feature Update report.

Step 3: Select a feature update profile

  1. Select a feature update profile.
  2. Select Ok.

Step 4: Open developer tools and generate

  1. Press F12 to open the developer pane in your browser.
  2. Select Generate report.

Step 5: Export the report as CSV

  1. Select Export.
  2. Select Yes at the prompt to export a .csv.

Step 6: Copy the export Request URL

  1. On the Network tab of the Developer pane in the browser watch for the the line starting with WindowsUpdatePerPolicyPerDeviceStatus.
  2. Select the line starting with WindowsUpdatePerPolicyPerDeviceStatus, this will contain the the Request URL.
  3. Copy the Request URL and save it for use later. It should look something like this: https://amsua0401repexpstorage.blob.core.windows.net.

Step 7: Open dataset settings in Power BI

  1. In Power BI go to the BI for Intune workspace.
  2. Select the dataset settings.

Step 8: Enter the Export URL parameters

  1. Expand Parameters.
  2. Enter the Export URL that you previously saved in the AzureAD Export URL parameter.
  3. Enter TRUE in the AzureAD Export URL Enable parameter.
  4. Select Apply.