smsagent.blog
  • docs.smsagent.blog
  • Custom Reporting in Microsoft Intune
    • Delivery Optimization Report
    • Windows Update for Business Custom Reporting
      • Power BI Report Walkthrough
      • Known issues / limitations
      • Change log
      • Deploy the solution
        • Create Azure Resources
        • Configure Azure Resources
        • Deploy the client-side script
        • Deploy the Azure automation runbooks
        • Configure the Power BI report
      • Adding additional language support
      • Table schema reference
    • Automating Data Exports from Microsoft Graph
      • Azure Automation account
        • Create / configure an Azure automation account
        • Grant API permissions
        • Create an Azure automation runbook
      • Azure Storage account
      • Automate Data Export to Azure Storage Account
      • Automate Data Export to Azure Monitor Logs
      • Creating / Troubleshooting Runbooks
      • Power BI
        • Connect Power BI to an Azure storage account data source
        • Connect Power BI to an Azure log analytics workspace as a data source
    • Managed Devices Report
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create a PowerBI report
      • MEM Managed Device Report template
      • Bonus! Unhealthy MEMCM Clients email report
    • Intune Assignments Report
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create a Power BI report
      • Change log
    • Patch My PC Report
      • A look at the Power BI reports
      • Change log
      • Video guides
      • Things to know
      • Create / configure an Azure automation account
      • Grant API permissions
      • Create / configure an Azure storage account
      • Create an Azure automation runbook
      • Create the Power BI report
      • Feedback
    • Windows 11 Hardware Readiness Report
    • Gathering Custom Inventory with Intune
      • Set up the Azure Resources
      • Create a Proactive remediations script package
      • Create a runbook
  • PowerShell Scripts Online Help
    • Get-AzSubscriptionActivityLog
  • Azure Solutions
    • Automated Azure Table Storage Backups
      • Change log
      • Deploy the solution
        • Create the Azure resources
        • Set the backup schedule
        • Add storage tables to the backup
        • Add role assignments to the storage account/s
        • Create a lifecycle management rule
      • Run a manual backup
      • Restore a backup
Powered by GitBook
On this page
  • Overview
  • Screenshots
  • Download
  • Configure the datasource

Was this helpful?

  1. Custom Reporting in Microsoft Intune
  2. Managed Devices Report

MEM Managed Device Report template

Here we will open the sample PowerBI template and create our own report from it

PreviousCreate a PowerBI reportNextBonus! Unhealthy MEMCM Clients email report

Last updated 1 year ago

Was this helpful?

Overview

I have created a sample PowerBI template for MEM managed devices that you can download and use. To use it, you must have first exported data from MS Graph into an Azure storage account using the provided automation account runbook in the previous sections. The template is configured to use exactly the properties that this runbook exports as well as the 3 exported files for each OS.

Screenshots

Download

Configure the datasource

  • Open the PowerBI template

  • Upon opening, you will be prompted for the storage account name and the container URL

  • You can retrieve the container URL from the storage account as follows:

    • In the Azure portal, in the storage account, navigate to the container where the 3 exported CSV reports are

    • Under Settings, click Properties

    • Copy the URL and paste it as the Container URL in the report

    • Important! Add a forward-slash to the end of the URL, eg https://.../intune-powerbi/

  • Click Load

  • You will be prompted for the Account key. Retrieve this from the storage account under Access Keys.

The data should then be imported into the report.

Download the PowerBI template .

here