What's new and planned for data integration
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
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).
- For a list of the previous wave's release plans, see the 2019 release wave 2 release plan.
- For a list of the next wave's release plans, see the 2020 release wave 2 release plan.
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 (
) shows which features have been released for public preview or early access and for general availability.
Common Data Model
Common Data Model is the shared metadata definition language, semantics, and tools used by applications and solutions to enable consistency of the meaning of data across applications and solutions.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| New Common Data Model standard entity definitions | Admins, makers, or analysts, automatically | - |  Sep 30, 2020 |
| Enhanced Common Data Model SDK functionality | Admins, makers, or analysts, automatically | Jun 30, 2020 |
Sep 30, 2020 |
| Empower out-of-the-box analytics | Admins, makers, or analysts, automatically | Aug 31, 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 |
|---|---|---|---|
| One-click to unlink dual-write environment | Admins, makers, or analysts, automatically | - | May 13, 2020 |
| Removal of tenant admin-level consent requirement | Admins, makers, or analysts, automatically | - | Jun 10, 2020 |
| Ability to add a company after linking your environment with pre-existing data | Admins, makers, or analysts, automatically | - | Jul 6, 2020 |
| Ability to bulk handle entity maps across environments | Admins, makers, or analysts, automatically | - | Aug 12, 2020 |
| Automated data movement operations between connected environments | Admins, makers, or analysts, automatically | - | Sep 30, 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 30, 2020 |
- |
| Export to Data Lake supported in additional regions | Admins, makers, or analysts, automatically | - | Sep 30, 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.
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 file | Admins, makers, or analysts, automatically | Sep 21, 2020 |
|
| Dataflow scheduling enhancements | Admins, makers, or analysts, automatically | - | Sep 30, 2020 |
| Reassign dataflow owner | Admins, makers, or analysts, automatically | - | Sep 30, 2020 |
Microsoft Power Platform gateway
The on-premises data gateway is a well-established product that is widely used by enterprises to access on-premises data sources from services like Power BI, Power Apps, Power Automate, and others.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Automate the installation of gateways | Admins, makers, or analysts, automatically | May 6, 2020 |
|
| Data source management enhancements | Admins, makers, or analysts, automatically | Sep 30, 2020 |
- |
Power Query Desktop
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Smart data extraction from text and CSV files in Power Query Desktop | Admins, makers, or analysts, automatically | Aug 12, 2020 |
- |
| Automatic table detection from Excel files | Admins, makers, or analysts, automatically | Sep 20, 2020 |
|
| Automatic table detection from JSON files | Admins, makers, or analysts, automatically | Sep 20, 2020 |
|
| SharePoint Online List connector | Admins, makers, or analysts, automatically | Sep 30, 2020 |
Power Query Online
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Copy and paste queries from Power Query Desktop into Power Query Online | Admins, makers, or analysts, automatically | Aug 31, 2020 |
|
| Power Query Online Query Editor Schema-only view | End users by admins, makers, or analysts | Sep 1, 2020 |
|
| Add column from examples | Admins, makers, or analysts, automatically | Sep 20, 2020 |
|
| Smart data extraction from web pages using Web by example | Admins, makers, or analysts, automatically | Sep 20, 2020 |
- |
| Azure China region support | End users, automatically | - | Sep 30, 2020 |
| Snowflake connector | End users, automatically | - | Sep 30, 2020 |
| View native query for supported connectors | End users, automatically | - | Sep 30, 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.