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 scenarios added to the higher education accelerator End users by admins, makers, or analysts - This feature is released. Jan 17, 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
Enabling sales order flow to Finance and Operations 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
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
Write existing data before turning on Dual Write Admins, makers, or analysts, automatically - Mar 2020
Back up and restore Dual Write artifacts Admins, makers, or analysts, automatically This feature is released. Nov 25, 2019 Mar 2020
Making Dual Write resilient to planned or unplanned maintenance Admins, makers, or analysts, automatically This feature is released. Nov 25, 2019 Mar 2020
Supporting multiple legal entities Admins, makers, or analysts, automatically This feature is released. Nov 25, 2019 Mar 2020

Export to data lake

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 This feature is released. Jan 31, 2020
Hydrate Azure Data Lake with Common Data Service data End users by admins, makers, or analysts This feature is released. Oct 31, 2019 This feature is released. Jan 31, 2020
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 This feature is released. Jan 31, 2020
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 This feature is released. Jan 31, 2020
Ensure the export to data lake service meets accessibility standards Admins, makers, or analysts, automatically - Mar 2020
Optimize performance for large data sets Admins, makers, or analysts, automatically - Mar 2020
Time series data Admins, makers, or analysts, automatically Mar 2020 To be announced

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 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 This feature is released. Oct 28, 2019
Certification portal Admins, makers, or analysts, automatically This feature is released. Jun 1, 2019 Mar 2020
Better enterprise connectivity to SQL Server Admins, makers, or analysts, automatically This feature is released. Oct 21, 2019 Mar 2020

Power Platform dataflows

Feature Enabled for Public preview General availability
One-time upload file support for file connectors Admins, makers, or analysts, automatically Mar 2020
Author dataflows in the Power Apps Maker Portal Admins, makers, or analysts, automatically This feature is released. Sep 10, 2019 This feature is released. Nov 15, 2019
Consume data from entities stored in Common Data Model folders Admins, makers, or analysts, automatically This feature is released. Sep 11, 2019 This feature is released. Nov 15, 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 This feature is released. Nov 30, 2019
New and enhanced connectors Admins, makers, or analysts, automatically This feature is released. Jan 13, 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 - This feature is released. Nov 11, 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

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.