Plan and prepare for data integration in 2023 release wave 2


The 2023 release wave 2 plan covers all new functionalities planned to be delivered to market from October 2023 to March 2024. In this article, you'll find the product overview and what's new and planned for data integration.


Data integration is foundational for the Microsoft Intelligent Data Platform, enabling data connectivity, transformation, and integration across hundreds of enterprise-critical cloud and on-premises data sources. Power Query enables users of Microsoft Fabric, Excel, Azure Synapse, Power Apps, Insights Apps, and other Microsoft products and services to ingest and transform data from hundreds of sources into the Microsoft data ecosystem.

In this upcoming release wave, we'll deliver various big data performance and high scale improvements to connectivity scenarios from Azure Synapse, Dataverse, Snowflake, Databricks, Google BigQuery, and Amazon Redshift, as well as many other Power Query connectors.

You can also expect several enhancements to the on-premises and VNet data gateways capabilities, delivering best-in-class hybrid data connectivity to users across multiple Microsoft cloud products and services.

Power Query experiences will also be enhanced with several new capabilities across Get Data and the Data Transformation experiences in the Power Query editor, making it even easier and more productive for users to work on their data prep tasks in a visual authoring environment.

We're also releasing significant improvements to Dataflows Gen2 within Data Factory in Microsoft Fabric. For more details on this roadmap, you can refer to Data Factory in Microsoft Fabric roadmap.

RSS Subscription Updates to data integration 2023 release wave 2

Investment areas

Investment areas

Power Query Online
Power Query Online is the data connectivity and data preparation experience for users across a wide variety of Microsoft products and services, including Power BI, Excel, Dynamics 365 Customer Insights, and more in a web-based environment. This experience integrates into a wide variety of Microsoft products and services, including dataflows in Power BI, Power Apps, Dynamic 365 Insights Applications, and several more. For more information, go to Power Query.

To learn more about the entire set of capabilities being delivered during this release wave, check out the release plan for data integration below:

For application administrators

User-impacting features to the user experience enabled automatically
User-impacting features should be reviewed by application administrators. This facilitates release change management and enables successful onboarding of new capabilities released to market. For the complete list, look for all features tagged "Users, automatically" in the release plan.

Features that must be enabled by application administrators
This release wave contains features that must be enabled or configured by administrators, makers, or business analysts to be available for their users. For the complete list, look for all features tagged "Users by admins, makers, or analysts" in the release plan.