What's new and planned for data integration

This topic lists features that are planned to release from October 2021 through March 2022. 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 2021 release wave 1 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.

Feature Enabled for Public preview General availability
Azure Synapse-based compute for dataflow tables in Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Nov 2021 -
Azure Synapse-based compute for Microsoft Dataverse tables in Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Nov 2021 -
Entity mapping UX enhancements Admins, makers, marketers, or analysts, automatically Mar 2022
Export dataflow as Power Query template Admins, makers, marketers, or analysts, automatically Mar 2022
Improved experience to update a dataflow's M query parameters Admins, makers, marketers, or analysts, automatically Mar 2022
Improved refresh history and diagnostics for dataflows Admins, makers, marketers, or analysts, automatically Mar 2022
Duplicate dataflows in Microsoft Power Platform environments Admins, makers, marketers, or analysts, automatically - Oct 2021
New capabilities to support relational database integration with Microsoft Dataverse tables Admins, makers, marketers, or analysts, automatically - Nov 2021

On-premises data gateway

The on-premises data gateway will continue to be an enterprise-grade product with features such as enhancements to load balancing, monitoring, and integration.

Feature Enabled for Public preview General availability
On-premises and VNet data gateway security roles Admins, makers, marketers, or analysts, automatically Nov 2021
Gateway diagnosability Admins, makers, marketers, or analysts, automatically Mar 2022
Deprecation of older versions of the on-premises data gateway Admins, makers, marketers, or analysts, automatically Mar 2022
Improved gateway and data source management in Power BI Admins, makers, marketers, or analysts, automatically Mar 2022

Power Query connectors

Power Query connectors enable connectivity to hundreds of applications, websites, databases, online services, and systems of record, with no code experience.

Feature Enabled for Public preview General availability
New Google Sheets connector Admins, makers, marketers, or analysts, automatically Mar 2022
Amazon Redshift support for native queries in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Azure HDInsight Hadoop Distributed File System (HDFS) connector available in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Browse support for the Dataverse connector in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Dataverse connector available in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Dataverse connector available in Excel Admins, makers, marketers, or analysts, automatically - Mar 2022
Dataverse support for native queries in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Google BigQuery support for native queries in Power Query Online and dataflows Users, automatically - Mar 2022
Google BigQuery support for service account authentication in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Google Sheets connector available in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Hive LLAP connector available in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
SharePoint list V2 connector improvements Admins, makers, marketers, or analysts, automatically - Mar 2022
SharePoint list V2 connector available in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Snowflake support for native queries in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Support for native queries in import and DirectQuery mode in the Power Query SDK Users by admins, makers, or analysts - Mar 2022

Power Query Online

Power Query is the data connectivity and data preparation experience for users across a wide variety of Microsoft products and services.

Feature Enabled for Public preview General availability
Get Data experience improvements Admins, makers, marketers, or analysts, automatically Mar 2022 -
Global Search Admins, makers, marketers, or analysts, automatically Mar 2022 -
New transform – Percentiles Admins, makers, marketers, or analysts, automatically Mar 2022
New transform – Rank Admins, makers, marketers, or analysts, automatically Mar 2022
New transform - Time-based binning Admins, makers, marketers, or analysts, automatically Mar 2022
Support for multi-value parameters Admins, makers, marketers, or analysts, automatically Mar 2022
Browse support for the SharePoint list connector in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically - Mar 2022
Date picker for entering dates Admins, makers, marketers, or analysts, automatically - Mar 2022
New Group By aggregate function - Count distinct values Admins, makers, marketers, or analysts, automatically - Mar 2022

Microsoft Power Platform connectors

The connector platform provides a rich set of connectors for customers and allows partners and customers to develop connectors efficiently.

Feature Enabled for Public preview General availability
Add existing custom connector to a solution Admins, makers, marketers, or analysts, automatically Mar 2022
Environment variable support in custom connector Admins, makers, marketers, or analysts, automatically Mar 2022

VNet data gateways

Enterprises that subscribe to VNet connectivity for their data services in Azure can seamlessly connect to Microsoft Power Platform using VNet data gateways.

Feature Enabled for Public preview General availability
VNet data gateway connectivity improvements Admins, makers, marketers, or analysts, automatically Mar 2022
VNet data gateway troubleshooting Admins, makers, marketers, or analysts, automatically Mar 2022

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.