smsagent.blog
Search…
smsagent.blog
docs.smsagent.blog
Custom Reporting in Microsoft Intune
Automating Data Exports from Microsoft Graph
Managed Devices Report
Patch My PC Report
A look at the Power Bi report
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
Powered By GitBook
Create the Power BI report
Here we will create a Power BI report from the template

Download

Download the Power BI template here.

Configure the datasource

  • Open the Power BI template with Power BI desktop
  • Upon opening, you will be prompted for the storage account name and the container name
  • Enter the name of the Azure storage account where you are saving the CSV exports
    • Make sure there are no spaces surrounding the storage account name
  • Enter the name of the container in the Azure storage account where the CSV files are exported to
  • Click Load
  • You will be prompted for the Account key. Retrieve this from the storage account under Access Keys.
Your data will then be imported into the report.
If you regenerate your storage account keys, you will need to update your Power BI report

Publish the report

Once your report has been created, you can publish it to the Power BI 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 and don't configure the report to refresh at the same time - try 30 minutes later for example. There is no need to use a data gateway as the storage account data source is also a cloud service.
Previous
Create an Azure automation runbook
Next
Feedback
Last modified 10mo ago
Copy link
Contents
Download
Configure the datasource
Publish the report