# Managed Devices Report ## Overview 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. ## High-Level Process 1. Create / configure an Azure automation account 2. Grant API permissions to the managed identity or Run as account 3. Create / configure an Azure storage account 4. Create the Automation runbook 5. Create the PowerBI report ## Requirements * Some familiarity with Azure administration * Some familiarity creating PowerBI reports * PowerShell knowledge * Appropriate permissions to create / configure the Azure resources --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.smsagent.blog/microsoft-endpoint-manager-reporting/managed-devices-report.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.