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 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
If you are a using hybrid mobile device management (MDM) with System Center Configuration Manager and Microsoft Intune, you want to retrieve your data from SCCM. The Intune Data Warehouse only contains Intune data. You can use an SCCM Power BI dashboard for your custom reports. For more information, see "Announcing the Power BI solution template for System Center Configuration Manager" and "Power BI content for Dynamics 365."
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.
- Get a link and use Power BI to get insight. For instructions, see Connect to the Intune Data Warehouse with Power BI.
- With your link, create a custom report with Power BI. For instructions, see Create a report from the OData feed with Power BI.
- Get more information about the Intune Data Warehouse API, the data model, and relationships between entities see Intune Data Warehouse API.
We'd love to hear your thoughts. Choose the type you'd like to provide:
Our feedback system is built on GitHub Issues. Read more on our blog.