smsagent.blog
Search
⌃K

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. 1.
    Create / configure an Azure automation account
  2. 2.
    Grant API permissions to the managed identity or Run as account
  3. 3.
    Create / configure an Azure storage account
  4. 4.
    Create the Automation runbook
  5. 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