What's new and planned for Common Data Model and data integration

This topic lists features that are planned to release from October 2019 through March 2020. Because this topic lists features that may not have released yet, delivery timelines may change and projected functionality may not be released (see Microsoft policy).

In the General availability column, the feature will be delivered within the month listed. The delivery date can be any day within that month. Released features show the full date, including the day of release.

This check mark (This feature is released. ) shows which features have been released for public preview or early access and for general availability.

Common Data Model

Feature Enabled for Public preview General availability
Additional capabilities in Common Data Model folders Admins, makers, or analysts, automatically Mar 2020
Improved experiences in Common Data Model and Power Query Online Admins, makers, or analysts, automatically Mar 2020
New Dynamics 365 Industry Accelerator solutions Admins, makers, or analysts, automatically Mar 2020
Public documentation for Common Data Model object model libraries Admins, makers, or analysts, automatically Mar 2020
New Common Data Model standard entity definitions Admins, makers, or analysts, automatically - Mar 2020

Data Integrator and Dual Write

Feature Enabled for Public preview General availability
Back up and restore Dual Write artifacts Admins, makers, or analysts, automatically Nov 2019 -
Making Dual Write resilient to planned or unplanned maintenance Admins, makers, or analysts, automatically Nov 2019 -
Supporting multiple legal entities Admins, makers, or analysts, automatically Nov 2019 -
Dual Write support for government cloud Admins, makers, or analysts, automatically Mar 2020 -
Actionable and user friendly error messages Admins, makers, or analysts, automatically - Mar 2020
Copy Finance and Operations data into Common Data Service Admins, makers, or analysts, automatically - Mar 2020
Enabling sales order flow to Finance and Operations Admins, makers, or analysts, automatically - Mar 2020
Ensure the Dual Write service meets accessibility standards Admins, makers, or analysts, automatically - Mar 2020
Improved error management with an ability to retry failed records Admins, makers, or analysts, automatically - Mar 2020
Show failed records for initial and catch-up writes Admins, makers, or analysts, automatically - Mar 2020
Simple and intuitive Dual Write user interface in Power Apps maker portal Admins, makers, or analysts, automatically - Mar 2020
Write existing data before turning on Dual Write Admins, makers, or analysts, automatically - Mar 2020

Enable analytics on Common Data Service data

Feature Enabled for Public preview General availability
Ability to link the Common Data Service environment to an Azure data lake Admins, makers, or analysts, automatically This feature is released. Oct 31, 2019 Dec 2019
Hydrate Azure Data Lake with Common Data Service data End users by admins, makers, or analysts This feature is released. Oct 31, 2019 Dec 2019
Support for initial and incremental data writes to Azure Data Lake End users by admins, makers, or analysts This feature is released. Oct 31, 2019 Dec 2019
Support for initial and incremental metadata changes in Azure Data Lake End users by admins, makers, or analysts This feature is released. Oct 31, 2019 Dec 2019
Add support to soft delete data Admins, makers, or analysts, automatically - Mar 2020
Configurable Snapshot interval Admins, makers, or analysts, automatically - Mar 2020
Dashboard showing count and trend of records with notifications on failures Admins, makers, or analysts, automatically - Mar 2020
Ensure the export to data lake service meets accessibility standards Admins, makers, or analysts, automatically - Mar 2020
Export to data lake support for government cloud Admins, makers, or analysts, automatically - Mar 2020
Historical data snapshots Admins, makers, or analysts, automatically - Mar 2020
Optimize performance for large data sets Admins, makers, or analysts, automatically - Mar 2020
Support smart partitioning Admins, makers, or analysts, automatically - Mar 2020
User friendly error messages Admins, makers, or analysts, automatically - Mar 2020

Gateway

Feature Enabled for Public preview General availability
Performance monitoring and diagnostics for gateways Admins, makers, or analysts, automatically This feature is released. Oct 1, 2019
Add intelligence to gateway load balancing Admins, makers, or analysts, automatically This feature is released. Oct 31, 2019
Manage gateways outside the default Power BI region Admins, makers, or analysts, automatically This feature is released. Oct 31, 2019 -
Automate gateway installation Admins, makers, or analysts, automatically Mar 2020
Gateway management enhancements Admins, makers, or analysts, automatically Mar 2020
Power BI refresh using the dataset owner's UPN Admins, makers, or analysts, automatically Mar 2020
Gateways now scale based on the CPU Admins, makers, or analysts, automatically - This feature is released. Oct 1, 2019
Enhanced security Admins, makers, or analysts, automatically - Mar 2020

Power Platform dataflows

Feature Enabled for Public preview General availability
Author dataflows in the Power Apps Maker Portal Admins, makers, or analysts, automatically This feature is released. Sep 10, 2019 Nov 2019
Consume data from entities stored in Common Data Model folders Admins, makers, or analysts, automatically This feature is released. Sep 11, 2019 Nov 2019

Power Query Desktop

Feature Enabled for Public preview General availability
Support for new AI Insights including Cognitive Services and custom Azure Machine Learning models Admins, makers, or analysts, automatically Nov 2019
New and enhanced connectors Admins, makers, or analysts, automatically Jan 2020
Moving the Power Query SDK to the Visual Studio Code SDK Admins, makers, or analysts, automatically Mar 2020
Support for using cached query results Admins, makers, or analysts, automatically Mar 2020
Data Profiling enhancements including better visualizations and more enhanced capabilities Admins, makers, or analysts, automatically - This feature is released. Oct 14, 2019
Enhancements to Data Profiling Admins, makers, or analysts, automatically - This feature is released. Oct 14, 2019
Custom connector and extensibility support Admins, makers, or analysts, automatically - Nov 2019
New and enhanced connectors in Power BI Admins, makers, or analysts, automatically - Mar 2020
Query Diagnostics enhancements Admins, makers, or analysts, automatically This feature is released. Oct 14, 2019 Mar 2020

Power Query Online

Feature Enabled for Public preview General availability
Parity with Power Query Desktop Admins, makers, or analysts, automatically - This feature is released. Oct 31, 2019
Smart data preparation Admins, makers, or analysts, automatically - This feature is released. Oct 31, 2019
New and enhanced connectors in Power Query Online Admins, makers, or analysts, automatically - Mar 2020

Power Apps and Power Automate Connector Platform

Feature Enabled for Public preview General availability
Improved command-line interface for connector developers Admins, makers, or analysts, automatically This feature is released. Oct 1, 2019
Use the Microsoft Excel Online connector in Power Apps Admins, makers, or analysts, automatically Mar 2020
New and enhanced connectors in Power Apps and Power Automate Admins, makers, or analysts, automatically Mar 2020 -
More open-source connectors are available on GitHub Admins, makers, or analysts, automatically - This feature is released. Oct 1, 2019
Support for Azure API Management policies in custom connectors Admins, makers, or analysts, automatically This feature is released. May 1, 2019 Oct 2019
Certification portal Admins, makers, or analysts, automatically This feature is released. Jun 1, 2019 Nov 2019
Better enterprise connectivity to SQL Server Admins, makers, or analysts, automatically Oct 2019 Mar 2020

Description of Enabled for column values:

  • End users, automatically: These features include change(s) to the user experience for end users and are enabled automatically.

  • Admins, makers, or analysts, automatically: These features are meant to be used by administrators, makers, or business analysts and are enabled automatically.

  • End users by admins, makers, or analysts: These features must be enabled or configured by the administrators, makers, or business analysts to be available for their end users.