What's new and planned for data integration

This topic lists features that are planned to release from April 2020 through September 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
New Common Data Model entity definitions for analytics Admins, makers, or analysts, automatically - Sep 2020
New Common Data Model standard entity definitions Admins, makers, or analysts, automatically - Sep 2020
Enhanced Common Data Model SDK functionality Admins, makers, or analysts, automatically This feature is released. Jun 30, 2020 Sep 2020
Empower out-of-the-box analytics Admins, makers, or analysts, automatically Aug 2020 To be announced

Dual-write

Dual-write provides a tightly coupled, near real-time and bi-directional integration between the Finance and Operations apps and Common Data Service.

Feature Enabled for Public preview General availability
Ability to add a company after linking your environment with pre-existing data Admins, makers, or analysts, automatically - Sep 2020
Ability to bulk handle entity maps across environments Admins, makers, or analysts, automatically - Sep 2020
Automated data movement operations between connected environments Admins, makers, or analysts, automatically - Sep 2020
Conflict resolution review Admins, makers, or analysts, automatically - Sep 2020
One-click to unlink dual-write environment Admins, makers, or analysts, automatically - Sep 2020
Removal of tenant admin-level consent requirement Admins, makers, or analysts, automatically - Sep 2020
Resiliency across planned and unplanned maintenance without admin intervention Admins, makers, or analysts, automatically - Sep 2020

Export to Data Lake

The Export to Data Lake service enables continuous replication of Common Data Service entity data to Azure Data Lake Storage, which can then be used to run analytics, such as Power BI reporting and machine learning.

Feature Enabled for Public preview General availability
Export to Data Lake support for Microsoft Government Cloud Admins, makers, or analysts, automatically Sep 2020 -
Export to Data Lake supported in additional regions Admins, makers, or analysts, automatically - Sep 2020

Microsoft Power Platform connectors

A critical part of data integration and the suite of products it supports — Power Apps and Power Automate — is connectivity to external data sources. The connector platform has two key objectives – providing a platform that allows partners and customers to develop connectors.

Feature Enabled for Public preview General availability
Integration of ISV Studio into the connector certification portal Admins, makers, or analysts, automatically This feature is released. Apr 30, 2020
Office 365 Groups Mail connector for Power Apps and Power Automate Admins, makers, or analysts, automatically This feature is released. Jun 15, 2020
Better enterprise connectivity to SQL Server with support for Windows authentication Admins, makers, or analysts, automatically Sep 2020
Improvements in the Planner connector Admins, makers, or analysts, automatically Sep 2020
Multi-region support for Azure services Admins, makers, or analysts, automatically Sep 2020
Telemetry for certified connectors Admins, makers, or analysts, automatically Sep 2020 -
FAQs for the certification process Admins, makers, or analysts, automatically - This feature is released. Apr 1, 2020
Give feedback directly from the documentation pages Admins, makers, or analysts, automatically - This feature is released. Apr 1, 2020
Provide documentation guidance for next steps when connectors and operators are deprecated Admins, makers, or analysts, automatically - This feature is released. Apr 1, 2020
Improved landing page experience for connectors Admins, makers, or analysts, automatically - This feature is released. May 1, 2020
Support for multiple account owners in the connector certification portal Admins, makers, or analysts, automatically - This feature is released. May 1, 2020
Submit documentation during the certification process Admins, makers, or analysts, automatically - This feature is released. May 15, 2020
Summary page with connectors and their metadata Admins, makers, or analysts, automatically - This feature is released. May 15, 2020
Improved certification experience for open sourced connectors Admins, makers, or analysts, automatically - This feature is released. Aug 31, 2020
Informative and consistent experience verifying the quality of connector artifacts Admins, makers, or analysts, automatically - This feature is released. Aug 31, 2020
Stronger documentation, tutorials, and guidelines for contributors to the open source repository Admins, makers, or analysts, automatically - This feature is released. Aug 31, 2020
Improved connector metadata within connectors documentation End users, automatically This feature is released. Feb 3, 2020 This feature is released. Aug 31, 2020
Improved experience downloading connector artifacts Admins, makers, or analysts, automatically - Sep 2020
Improved partner story and experience in our connector certification program Admins, makers, or analysts, automatically - Sep 2020
More certified and custom connectors in our open source repository Admins, makers, or analysts, automatically - Sep 2020
SAP ERP connector for Power Apps and Power Automate Admins, makers, or analysts, automatically - Sep 2020
Stronger integration of the open source repository with custom connectors Admins, makers, or analysts, automatically - Sep 2020
Support for connection parameters when building custom connectors Admins, makers, or analysts, automatically - Sep 2020
Support for ordering operation parameters when building connectors Admins, makers, or analysts, automatically - Sep 2020
Support for smart polling triggers Admins, makers, or analysts, automatically Sep 2020 Sep 2020

Microsoft Power Platform dataflows

Microsoft Power Platform dataflows provide a no-code experience based on Power Query Online for non-technical users to connect, transform, and enrich data from a wide variety of data sources into Common Data Service and Azure Data Lake Storage in Common Data Model format.

Feature Enabled for Public preview General availability
Generate a new dataflow from Power Query queries in an existing Excel or Power BI Desktop file Admins, makers, or analysts, automatically Sep 2020
Dataflow scheduling enhancements Admins, makers, or analysts, automatically - Sep 2020
Dataflows actions and triggers for Power Automate Admins, makers, or analysts, automatically - Sep 2020
Improved dataflow load performance and reliability Admins, makers, or analysts, automatically - Sep 2020

Microsoft Power Platform gateway

Feature Enabled for Public preview General availability
Automate the installation of gateways Admins, makers, or analysts, automatically Sep 2020
Data source management enhancements Admins, makers, or analysts, automatically - Sep 2020

Power Query Desktop

Feature Enabled for Public preview General availability
Automatic table detection from Excel files Admins, makers, or analysts, automatically Sep 2020
Automatic table detection from JSON files Admins, makers, or analysts, automatically Sep 2020
SharePoint Online List connector End users, automatically Sep 2020
Smart data extraction from text and CSV files in Power Query Desktop Admins, makers, or analysts, automatically Sep 2020 -
Hive LLAP End users, automatically This feature is released. Mar 9, 2020 Sep 2020

Power Query Online

Feature Enabled for Public preview General availability
Add column from examples Admins, makers, or analysts, automatically Sep 2020
Copy and paste queries from Power Query Desktop into Power Query Online Admins, makers, or analysts, automatically Sep 2020
Power Query Online Query Editor Schema-only view End users by admins, makers, or analysts Sep 2020
Smart data extraction from web pages using Web by example Admins, makers, or analysts, automatically Sep 2020 -
Azure China region support End users, automatically - Sep 2020
Exchange Online connector End users, automatically - Sep 2020
Power Query connector improvements End users, automatically - Sep 2020
Query diagnostics improvements Admins, makers, or analysts, automatically - Sep 2020
Snowflake connector End users, automatically - Sep 2020
Support for beta tags for connectors End users, automatically - Sep 2020
View native query for supported connectors End users, automatically - Sep 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.

For a list of the countries or regions where Dynamics 365 business applications are available, see the International availability guide. For more information about geographic areas and data centers (regions), go to the Dynamics 365 and Microsoft Power Platform availability page.