Managed Devices Report

This guide demonstrates how to regularly export data from Microsoft Graph using Azure automation, dump data to Azure blob storage and create a PowerBI report from the data.

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