Public preview Microsoft Intune Data Warehouse. With a dataset spanning up to 90 days of historical data, you can connect the Data Warehouse to Power BI, Excel (or another analytics tool that supports OData feeds) to view historical trends, get daily snapshots and create other custom reports across multiple tables.

To get started using the Intune Data Warehouse, open your Intune admin console on the Azure portal, click on the Intune Data Warehouse tile, and then follow the instructions on the subsequent blade.

Getting started is a cinch with our pre-configured Power BI file

If you’re using Power BI, we’ve created a Power BI file that makes it easy to get started working with the data stored in your Intune Data Warehouse. Our Power BI file is pre-configured with  reports and charts that you can easily connect to your tenant’s data. The reports and charts included in this file are designed to give you additional insight into the status of: devices, enrollment, app protection policies, compliance policies, device configuration profiles, software updates and device inventory. This file comes pre-populated with some user-friendly filters, you can easily apply more advanced filters by using the Power BI filter pane. For more information on how to use the Intune Data Warehouse with Power BI, including details on how to create your own custom reports, check out our documentation site.

Use the Intune Data Warehouse to build reports that provide insight into your enterprise mobile environment. For example, some of the reports include:

  • Trend of users enrolling in Intune so you can optimize your license purchases
  • App and OS versions breakdown so you can review that status of mobile devices
  • Enrollment and device compliance trends so you can smoothly roll out policy updates

The Data Warehouse provides you access to more information about your mobile environment than the Azure portal. With the Intune Data Warehouse you can access:

  • Historical Intune data
  • Data refreshed on a daily cadence
  • A data model using the OData standard
Important

You can try out the latest functionality of the Data Warehouse by using the beta version. To use the beta version, your URL must contain the query parameter api-version=beta. The beta version offers features before they are made generally available as a supported service. As Intune adds new features, the beta version may change behavior and data contracts. Any custom code or reporting tools dependent on the beta version may break with ongoing updates.