Update 9/7/2021

I found out the column I was user for what I thought was primary user was in fact enrollment user. I had to add another table called userDeviceAssociations and redo some of the relationships on the tables but I got it corrected now. Please download the new MEM Dashboard file to get the corrections.

Summary

This will Power BI report has the following information in it:

• Device usage
• Updates Compliance
• Hardware Inventory
• Application Inventory
• Endpoint Security

Prerequisites

• PowerBI Desktop x64 or Power BI Report Server
• MEM Dashboard
• Update Compliance Enabled
• How to retrieve your Intune Data Warehouse URL
• Intune Deploy PowerShell Scripts with Reporting Capabilities
• Power BI Pro License (if you want to publish for others in your organization to see)

Steps

1. Open MEM Dashboard

2. You will be prompted to login after it tries to retrieve data from my environment which it will fail. Click Cancel.

3. Click close on the refresh screen.

4. Right click on Devices on the right hand side and select Edit query.

5. Right click on Source and select Edit Settings. On the OData Feed, change the URL to the data warehouse URL that should be in your notepad.

6. Click Organizational account, then click Sign in.

7. Follow any prompts to login to your M365 account, chances are if you are already logged it then you can just click connect.

8. Repeat this step for all the tables except for UpdateDeployment, AppInventory, and DeviceInventory.

9. Navigate to the Azure Portal
10. Select Analytics on the left side then select Log Analytics Workspaces.
11. Select your workspace, then select Solutions. Select WaaSUpdateInsights.
12. Select Update Compliance window.
13. Select Logs.
14. Change the time range to 7 days and type in "WaaSDeploymentStatus" in the query field. Click Run to execute the query.
15. Select Export and Export to Power BI(M query)
16. Open the PowerBIQuery.txt file that gets downloaded. Copy all the contents inside it.
17. Go back to Power BI and left click on UpdateDeployment then select Advance Editor.
18. Delete all the content that is in the UpdateDeployment Advance Editor screen and paste in what you got from the PowerBIQuery.txt file that you downloaded from step above. Click done to save the update.
19. Click Close & Apply in the top right corner.
20. Wait for the report to collect the data.

You have completed the deployment of the dashboard, don't forget to save it. Your dashboards should look something like these.