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 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.
- In the Intune console select the Reports blade.
- Select Windows Updates (preview).
- Select the Reports tab.
- Select the Windows Feature Update report.
- Select a feature update profile.
- Select Ok.
- Press F12 to open the developer pane in your browser.
- Select Generate report.
- Select Export.
- Select Yes at the prompt to export a .csv.
- On the Network tab of the Developer pane in the browser watch for the the line starting with WindowsUpdatePerPolicyPerDeviceStatus.
- Select the line starting with WindowsUpdatePerPolicyPerDeviceStatus, this will contain the the Request URL.
- Copy the Request URL and save it for use later. It should look something like this, "https://amsua0401repexpstorage.blob.core.windows.net".
- In Power BI go to the BI for Intune workspace.
- Select the dataset settings.
- Expand Parameters.
- Enter the Export URL that you previously saved in the AzureAD Export URL parameter.
- Enter TRUE in the AzureAD Export URL Enable parameter.
- Select Apply.
