What's new and planned for data integration

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 previous wave's release plans, go to 2021 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
VNet data gateway - additional security roles Users by admins, makers, or analysts Sep 2022
VNet data gateway - diagnostics logs in admin portal Users by admins, makers, or analysts Sep 2022
VNet data gateway - sovereign cloud availability Users by admins, makers, or analysts Sep 2022
VNet data gateway - connectivity for Power BI and Microsoft Power Platform dataflows Admins, makers, marketers, or analysts, automatically - Sep 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
Azure Synapse-based compute for dataflow tables in Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Sep 2022 -
Azure Synapse-based compute for Microsoft Dataverse tables in Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Sep 2022 -
Connections page now lists dataflows used by connection Users, automatically Sep 2022
Enhanced refresh history user experience for dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
Public preview of the next generation Power BI dataflows Admins, makers, marketers, or analysts, automatically Sep 2022
Integrate relational data sources with Microsoft Dataverse tables Admins, makers, marketers, or analysts, automatically - Jun 2022
Standard dataflows in Power Apps – support for loading data into unique identifier fields Admins, makers, marketers, or analysts, automatically - Sep 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 2022 -
Amazon Redshift support for native queries in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
Azure HDInsight HDFS connector available in Power BI dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
Google BigQuery support for Azure Active Directory-based single sign-on for Power BI DirectQuery Admins, makers, marketers, or analysts, automatically Sep 2022
Google BigQuery support for native queries in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
Hive LLAP connector available in Power BI dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
PostgreSQL support for native queries in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
SharePoint Lists V2 connector available in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
Snowflake support for native queries in Power Query Online and dataflows Admins, makers, marketers, or analysts, automatically Sep 2022 -
Support for native queries in import and DirectQuery mode in the Power Query SDK Admins, makers, marketers, or analysts, automatically Sep 2022 -
Certified connectors available in Power BI dataflows Admins, makers, marketers, or analysts, automatically - Sep 2022
Common Data Model folder view feature in Azure Data Lake Storage connector Admins, makers, marketers, or analysts, automatically - Sep 2022
Essbase connector available in Power BI dataflows Admins, makers, marketers, or analysts, automatically - Sep 2022
Hadoop Distributed File System (HDFS) connector available in Power BI dataflows Admins, makers, marketers, or analysts, automatically - Sep 2022
Informix connector available in Power BI dataflows Admins, makers, marketers, or analysts, automatically - Sep 2022
Marketo connector available in Power BI dataflows Admins, makers, marketers, or analysts, automatically - Sep 2022
OLE DB connector available in Power BI dataflows Admins, makers, marketers, or analysts, automatically - Sep 2022
Support for custom connectors in Power BI dataflows Admins, makers, marketers, or analysts, automatically - Sep 2022

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 -
Improvements to the query folding indicator Users, automatically Sep 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 2022
New transform - rank Admins, makers, marketers, or analysts, automatically - Aug 2022
Connect to data with greater simplicity and flexibility Admins, makers, marketers, or analysts, automatically - Sep 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.