# 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