Use the Microsoft Intune Data Warehouse

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

Data Warehouse benefits

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

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


If you are a using co-managed mobile device management (MDM) with Microsoft Configuration Manager and Microsoft Intune, you need to retrieve your data from Configuration Manager. The Intune Data Warehouse only contains Intune data. You can use a Configuration Manager Power BI dashboard for your custom reports. For related information, see Power BI Desktop.


You can now use the v1.0 version of the Intune Data Warehouse by setting the query parameter api-version=v1.0. Updates to collections in the Data Warehouse are additive in nature and do not break existing scenarios.

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.

Next steps