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