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
  • Connect to Azure Blob storage
  • Publish the report

Was this helpful?

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

Create a PowerBI report

Here we will look at how to connect PowerBI to our storage account and import our data

PreviousCreate an Azure automation runbookNextMEM Managed Device Report template

Last updated 4 years ago

Was this helpful?

Connect to Azure Blob storage

  • Open PowerBI desktop and choose Get Data

  • In the Azure section, choose Azure Blob Storage

  • In the next window, enter the Account name of the storage account

  • Next you will be prompted for the Account key. You'll find this in the storage account under Access Keys.

If you regenerate your storage account keys, you will need to update your PowerBI report

  • Click Connect

  • In the Navigator window, select the container that holds the exported CSV files. You'll see the files in the container on the right

  • Click Transform Data

  • In the Power Query Editor window, you'll see the 3 files listed. Rename the query for one of the files, for example Android_Devices, then click on the Binary link in the Content column for the AndroidDevices.csv. This will transform the data from the CSV file into the query.

  • Staying in the Query Editor, right-click the blank space on the left under Queries [1], choose New Query > Recent sources, and select the storage account source you just used. This will bring up the Navigator window again. Repeat the above steps, selecting the container and transforming the content until you have all 3 queries added:

  • Finally, in the Home menu, click Close and Apply. The data will then be imported from the CSV files into the report.

From here, you can build out your report as you wish.

Publish the report

Once your report has been created, you can publish it to the PowerBI service by clicking Publish on the Home menu.

Once published, you can schedule the data to refresh periodically to keep the report up to date. Do not refresh more frequently than the schedule of your automation runbook. You do not need to use a data gateway as the storage account datasource is also a cloud service.