What's new and planned for data integration
This topic lists features that are planned to release from April 2021 through September 2021. Because this topic lists features that may not have released yet, delivery timelines may change and projected functionality may not be released. For more information, go to Microsoft policy.
- For a list of the previous wave's release plans, go to 2020 release wave 2 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 date of release.
This check mark (
) shows which features have been released for public preview or early access and for public preview, early access, and general availability.
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 Microsoft Dataverse and Azure Data Lake Storage in Common Data Model format.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Azure Synapse-based compute for Microsoft Dataverse tables in Dynamics 365 Customer Insights | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Duplicate dataflows in Microsoft Power Platform environments | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| New capabilities to support relational database integration with Microsoft Dataverse tables | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Azure Synapse-based compute for dataflow tables in Dynamics 365 Customer Insights | Admins, makers, marketers, or analysts, automatically | Mar 2021 | Sep 2021 |
Microsoft Power Platform gateway
On-premises data gateway.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Security improvements for gateway and data source management | Admins, makers, marketers, or analysts, automatically | Sep 2021 |
Power Query connectors
Power Query connectors provide out-of-the-box connectivity to hundreds of sources.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Adobe Analytics connector enhancements | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Amazon Redshift connector support for Azure AD SSO | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Amazon Redshift connector support for native query | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Dataverse connector availability in dataflows | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Dataverse connector availability in Excel | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Dataverse connector support for multiple environments | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Dataverse connector support for native query | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Google BigQuery connector native query support | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Navigator performance improvements for Google BigQuery connector | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Navigator performance improvements for Snowflake connector | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Updating Google Analytics connector to use Google Analytics API V4 | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
Power Query Online
Power Query is the data connectivity and data preparation experience for users across a wide variety of Microsoft products and services, including Power BI, Excel, Customer Insights, and several more.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Gateways support for non-admin users | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Load data from a local file without using a gateway | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Modify data used in Power BI reports created from manually entered data | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Performance improvements for Power Query | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Power Query Get Data experience improvements | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Use data from a CSV file when creating quick reports in Power BI | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Use data from a PDF file when creating quick reports in Power BI Online | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Use data from an Excel file when creating quick reports in Power BI | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Use Microsoft Dataverse data when creating quick reports in Power BI Online | Admins, makers, marketers, or analysts, automatically | Sep 2021 | |
| Custom column enhancements to specify column type | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
| Text/CSV by example data extraction | Admins, makers, marketers, or analysts, automatically | - | Sep 2021 |
Description of Enabled for column values:
Users, automatically: These features include changes to the user experience and are enabled automatically.
Admins, makers, marketers, or analysts, automatically: These features are meant to be used by administrators, makers, marketers, or business analysts and are enabled automatically.
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 users.
For a list of the countries or regions where Dynamics 365 business applications are available, go to the International availability guide. For more information about geographic areas and datacenters (regions), go to the Dynamics 365 and Microsoft Power Platform availability page.