In this guide we will export data from Microsoft Graph for Intune managed devices and create a PowerBI report using the exported data as a datasource.
Benefits of this approach include:
Use PowerBI to create your own custom reports from any Microsoft Graph data
Reports support using a scheduled refresh in the PowerBI service for keeping data up-to-date
Everything is in the cloud - there is no requirement for on-prem resources or a data gateway
Use a managed identity or a Run as account for simplified, secure no-credential authentication
Graph data can be manipulated using PowerShell before export allowing customization of the final data set
I've also included a sample PowerBI template that works with the automation runbook provided in this guide.
Create / configure an Azure automation account
Grant API permissions to the managed identity or Run as account
Create / configure an Azure storage account
Create the Automation runbook
Create the PowerBI report
Some familiarity with Azure administration
Some familiarity creating PowerBI reports
Appropriate permissions to create / configure the Azure resources