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 April 2022 through September 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 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.
Azure Virtual Network data gateways
Azure Virtual Network connectivity for Microsoft Power Platform using VNet data gateways.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| VNet data gateway - high availability and load balancing support | Users by admins, makers, or analysts | 
May 16, 2022 |
Dataflows
Dataflows give users a low-code self-service data preparation experience using Power Query and enables them to integrate data across Power BI, Power Platform, Dynamics 365, and Azure.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Integrate relational data sources with Microsoft Dataverse tables | Admins, makers, marketers, or analysts, automatically | - |
Aug 10, 2022 |
On-premises data gateway
On-premises data gateways access data sources and transfer petabytes of data. We're focusing on making these gateways an enterprise-grade product.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Improved gateway and data source management in Power BI | Admins, makers, marketers, or analysts, automatically |
May 15, 2022 |
May 15, 2022 |
Power Query connectors
Power Query connectors provide out-of-the-box connectivity to hundreds of sources.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Dataverse connector available in Excel | Admins, makers, marketers, or analysts, automatically |
May 31, 2022 |
- |
| Dataflows connector available in Excel | Admins, makers, marketers, or analysts, automatically |
Jun 27, 2022 |
- |
| SharePoint Online list V2 connector available in Power Query Online and dataflows | Admins, makers, marketers, or analysts, automatically |
Sep 13, 2022 |
- |
| Certified connectors available in Power BI dataflows | Admins, makers, marketers, or analysts, automatically | - |
Sep 1, 2022 |
| Power Query Visual Studio Code-based SDK | Admins, makers, marketers, or analysts, automatically |
Sep 18, 2022 |
To be announced |
Power Query Online
Power Query is the primary data connectivity and data preparation experience across Microsoft products and services.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Datamarts - data ingestion | Admins, makers, marketers, or analysts, automatically |
May 26, 2022 |
- |
| New transform – percentiles | Admins, makers, marketers, or analysts, automatically | - |
May 6, 2022 |
| Get data - simplify the process of connecting to data sources that support Azure AD-based authentication | Admins, makers, marketers, or analysts, automatically | - |
Jul 11, 2022 |
| New transform - rank | Admins, makers, marketers, or analysts, automatically | - |
Jul 29, 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.