What's new and planned for data integration
Important
This content is archived and is not being updated. For the latest documentation, go to Integrate data into Microsoft Dataverse. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.
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 next wave's release plans, go to 2022 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 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 31, 2022 |
|
| Environment variable support in custom connectors | Admins, makers, marketers, or analysts, automatically |
Mar 31, 2022 |
|
| Moving 100 connectors from preview to production | Users, automatically | - | Mar 2022 |
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 |
|---|---|---|---|
| Duplicate dataflows in Microsoft Power Platform environments | Admins, makers, marketers, or analysts, automatically | - |
Oct 15, 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 data gateway security roles | Admins, makers, marketers, or analysts, automatically |
Mar 31, 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 |
Nov 15, 2021 |
|
| Navigator performance improvements for Google BigQuery connector | Admins, makers, marketers, or analysts, automatically |
Jan 1, 2022 |
- |
| Browse support for the Dataverse connector in Power Query Online and dataflows | Admins, makers, marketers, or analysts, automatically |
Jan 24, 2022 |
- |
| Dataverse connector availability in Power Query Online and dataflows | Admins, makers, marketers, or analysts, automatically |
Jan 24, 2022 |
- |
| Google BigQuery support for service account authentication in Power Query Online and dataflows | Admins, makers, marketers, or analysts, automatically |
Feb 14, 2022 |
- |
| SharePoint list V2 connector improvements | Admins, makers, marketers, or analysts, automatically |
Feb 14, 2022 |
- |
| Support for system-level proxy in Power Query SDK | Users by admins, makers, or analysts | - |
Feb 14, 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 |
|---|---|---|---|
| Support for multi-value parameters | Admins, makers, marketers, or analysts, automatically |
Jan 14, 2022 |
|
| Get Data experience improvements | Admins, makers, marketers, or analysts, automatically |
Mar 31, 2022 |
- |
| Date picker for entering dates | Admins, makers, marketers, or analysts, automatically | - |
Jan 14, 2022 |
| New Group By aggregate function - count distinct values | Admins, makers, marketers, or analysts, automatically | - |
Jan 14, 2022 |
| Global search | Admins, makers, marketers, or analysts, automatically | - |
Mar 8, 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 |
Nov 30, 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.