Build a Power BI Dashboard with the Intune Data Warehouse
Connect Power BI to the Intune Data Warehouse and explore the example dashboard. Review the OData connection and available device, app and compliance data.
The Intune Data Warehouse provides a treasure trove of structured data that is incredibly useful for building reports. In this guide I will show you exactly how to connect to the Intune Data Warehouse with Power BI, and I will also share a ready-made example dashboard so you can get insights into your environment in minutes instead of days. Whether you manage a handful of devices or thousands, tapping into the Intune Data Warehouse turns raw management data into a clear, actionable picture for your stakeholders.
What is the Intune Data Warehouse
The Intune Data Warehouse is a collection of multiple structured data tables that are linked together through relations, designed specifically for reporting purposes. It uses the OData model, so you can access both daily snapshots and historical data going back several weeks. One important detail to remember is that the Intune Data Warehouse only surfaces Intune-managed devices – co-managed devices have to be retrieved separately via Configuration Manager. You can find the OData feed string in the Intune admin center under Reports -> Data warehouse, and that single URL is the key that unlocks every table for your reports.
Because the data is already modelled and normalised, you spend far less time wrangling raw exports and far more time analysing trends such as compliance, configuration drift, and application rollout. If you want to go even further with reporting, take a look at my post on Intune advanced analytics for a comparison of the native options.
Useful links:
Install Power BI Desktop on your device
Before you can query any tables, you need the right tool. Power BI Desktop is free and ships with a dedicated connector that knows how to authenticate against the warehouse, so there is no need to handcraft the OData URL.
- Download and install Power BI Desktop from the Windows Store
Access the Intune Data Warehouse in Power BI
With Power BI Desktop installed, the next step is to access the Intune Data Warehouse using the built-in connector. Follow the steps below and you will have live tables loaded into your model in just a few clicks.
- Open Power BI Desktop
- Select Get data
- Search for Intune Data Warehouse and click Connect
- Select Don’t warn me again for this connector and click Continue
- Select the history you want to have and click OK
- Click Sign in and authenticate with your account
- Click Connect
- Select the Tables you need for the reporting
If you only need a high-level overview, start with the device, application, and configuration tables. You can always add more tables later, but pulling everything at once will slow down the initial load considerably.
Import the ready-to-use Intune Data Warehouse dashboard
Rather than building every visual from scratch, you can import my ready-to-use dashboard that is already wired up to the Intune Data Warehouse model. After downloading the file, you only need to point it at your own tenant and refresh.
- Download the Intune Dashboard from my Github repository
- Click refresh
- Sign in with your credentials
- Have fun with the dashboard
App View
The app view aggregates application install status across your fleet so you can quickly spot failed deployments and adoption gaps.
Device view
The device view breaks down enrollment, operating system, and ownership so you can track the health of every managed endpoint.
Config Profile
The configuration profile view reports assignment results so you can confirm that policies actually land on the devices you targeted.
Conclusion
With this dashboard you get a high-level overview of your environment in minutes, all powered by the Intune Data Warehouse. You can extend it with other data sources, expand it further, and customize it for your own needs – and the best part is you don’t have to worry about the design. Once you are comfortable connecting Power BI to the Intune Data Warehouse, reporting on your Intune estate becomes a repeatable, automated routine rather than a manual chore.
Stay healthy, Cheers
Jannik
11.02.2023: Error 0x80040E4E
If you got this error you have to change the regional setting: https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions