This Power BI report is more or less a mirror of what is available in Endpoint Analytics and is built from the same data. It allows you to see which devices in Intune are ready for Windows 11 and which are not and the reasons why.
The report uses the same process as the other reports in this site, ie an Azure automation account runbook exports the data from Microsoft Graph and sends it in CSV format to an Azure storage account container. The Power BI report then connects to the storage account and uses the CSV file as the source for the report. Scheduling the runbook to run regularly and scheduling a refresh on the Power BI report will keep the data up-to-date.
Configure Azure Resources
If you've already created any of my other reports in this site or used the same process, ie Azure automation runbook > Azure blob storage, you'll already have the Azure resources in place to run this report. Otherwise you'll need to create them using the guides below.
Upon opening, you'll be prompted for your storage account name and the container name:
If you haven't connected to the storage account with Power BI before, you'll be prompted for the account key, which you can find under Access keys in the storage account.
Once the data has loaded in, you can publish your report to the Power BI service and set a refresh schedule. Make sure there is an offset between when the automation runbook is scheduled and when the Power BI report is scheduled to refresh.