Try It
Print

Configure Intune Export API

Copy the URL link to this section to share

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 in order 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 in order 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. In the Intune console select the Reports blade.
  2. Select Windows Updates (preview).
(click to enlarge)
Step

  1. Select the Reports tab.
  2. Select the Windows Feature Update report.
(click to enlarge)
Step

  1. Select a feature update profile.
  2. Select Ok.
(click to enlarge)
Step

  1. Press F12 to open the developer pane in your browser.
  2. Select Generate report.
(click to enlarge)
Step

  1. Select Export.
  2. Select Yes at the prompt to export a .csv.
(click to enlarge)
Step

  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".
(click to enlarge)
Step

  1. In Power BI go to the BI for Intune workspace.
  2. Select the dataset settings.
(click to enlarge)
Step

  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.
(click to enlarge)