MC1188216 – Plan for Change: Update to Intune Data Warehouse infrastructure

Product:

Intune, Microsoft 365 admin center, Microsoft 365 Apps, Power BI

Platform:

Developer, Online, World tenant

Status:

Change type:

Admin impact

Links:

Details:

Summary:
In mid-February 2026, the Intune Data Warehouse will be updated with a new architecture, resetting historical data to about 30 days, changing licensing definitions, and regenerating surrogate keys. The Intune Data Warehouse (beta) Power BI connector will be discontinued; users must switch to the OData feed.

Details:
Expected in mid-February 2026, as part of our modernization efforts, we are updating the Intune Data Warehouse with a new architecture to enhance scalability, performance, and align with the reporting infrastructure. The Intune Data Warehouse provides structured access to historical Intune data through an OData API, enabling you to build custom reports and dashboards using tools like Power BI and Excel. This update includes several key changes to be aware of:
Historical data reset: Once updated, the data will be reset and there will only be approximately 30 days of data.
Updated licensing definition: The "IntuneLicensed" property will now include all forms of Intune licensing and grace periods.
Surrogate key refresh: Surrogate keys will be regenerated as part of the infrastructure update.

Change Category:
XXXXXXX ... free basic plan only

Scope:
XXXXXXX ... free basic plan only

Release Phase:

Created:
2025-11-20

updated:
2025-11-20

Task Type

XXXXXXX ... free basic plan only

Docu to Check

XXXXXXX ... free basic plan only

MS How does it affect me

XXXXXXX ... free basic plan only

MS Preperations

XXXXXXX ... free basic plan only

MS Urgency

XXXXXXX ... free basic plan only

MS workload name

XXXXXXX ... free basic plan only

summary for non-techies**

XXXXXXX ... free basic plan only

Direct effects for Operations**

Historical Data Reset
Resetting historical data to only 30 days will lead to loss of long-term data analysis capabilities, affecting reporting accuracy and trend analysis.
   - roles: Data Analyst, IT Administrator
   - references: https://learn.microsoft.com/intune/intune-service/developer/reports-api-url

Discontinuation of Power BI Connector
The discontinuation of the Intune Data Warehouse (beta) Power BI connector will disrupt existing reporting workflows, requiring immediate transition to the OData feed.
   - roles: Business Intelligence Developer, Data Analyst
   - references: https://learn.microsoft.com/intune/intune-service/developer/reports-proc-create-with-odata#connect-to-the-odata-feed-for-the-intune-data-warehouse-for-your-tenant

Surrogate Key Refresh
Regeneration of surrogate keys may break existing data relationships and dependencies, leading to potential data integrity issues in reports.
   - roles: Database Administrator, Data Analyst
   - references: https://techcommunity.microsoft.com/blog/intunecustomersuccess/integrating-azure-data-factory-and-the-microsoft-intune-export-api/4093359

Updated Licensing Definitions
Changes in licensing definitions may lead to confusion and misreporting of user licenses, impacting compliance and financial reporting.
   - roles: Compliance Officer, IT Administrator
   - references: https://learn.microsoft.com/intune/intune-service/developer/reports-api-url

Need for Data Backup
Failure to back up historical data before the update will result in irreversible data loss, affecting historical reporting and analysis.
   - roles: Data Analyst, IT Administrator
   - references: https://learn.microsoft.com/intune/intune-service/developer/reports-proc-create-with-odata#connect-to-the-odata-feed-for-the-intune-data-warehouse-for-your-tenant

Configutation Options**

XXXXXXX ... paid membership only

Opportunities**

Transition to OData Feed for Reporting
With the discontinuation of the Intune Data Warehouse (beta) Power BI connector, transitioning to the OData feed will allow for continued access to Intune data for reporting and analytics. This change can improve the efficiency of data retrieval and reporting processes.
   - next-steps: Identify all existing reports using the Power BI connector and create a migration plan to switch to the OData feed. Train users on how to connect and utilize the OData feed for their reporting needs.
   - roles: Data Analysts, IT Administrators, Business Intelligence Developers
   - references: https://learn.microsoft.com/intune/intune-service/developer/reports-api-url" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/intune/intune-service/developer/reports-api-url, https://learn.microsoft.com/intune/intune-service/developer/reports-proc-create-with-odata#connect-to-the-odata-feed-for-the-intune-data-warehouse-for-your-tenant

Backup Historical Data
Before the data reset, backing up historical data will ensure that important insights and trends are not lost. This proactive measure can enhance data integrity and availability for future analysis.
   - next-steps: Establish a backup process for historical data using existing tools or services. Communicate the importance of this backup to all relevant stakeholders.
   - roles: Data Analysts, IT Administrators, Compliance Officers
   - references: https://techcommunity.microsoft.com/blog/intunecustomersuccess/integrating-azure-data-factory-and-the-microsoft-intune-export-api/4093359

Review Licensing Definitions and Reporting Behavior
Understanding the updated licensing definitions and reporting behavior can help organizations better manage their Intune licenses and optimize usage. This knowledge can lead to improved compliance and resource allocation.
   - next-steps: Conduct a training session or workshop to educate stakeholders on the new licensing definitions and reporting behavior. Update internal documentation to reflect these changes.
   - roles: IT Administrators, Finance Officers, Compliance Officers
   - references: https://learn.microsoft.com/intune/intune-service/developer/reports-api-url" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/intune/intune-service/developer/reports-api-url

Potentional Risks**

XXXXXXX ... paid membership only

IT Security**

XXXXXXX ... paid membership only

explanation for non-techies**

XXXXXXX ... free basic plan only