Plan and prepare for data integration in 2022 release wave 2

Important

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

Overview

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 Power BI, Excel, Azure Synapse, Power Apps, and other Microsoft products and services to ingest and transform data from hundreds of sources into the Microsoft data ecosystem with the M language. In this upcoming release wave, we will 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, like additional security roles, logs, and diagnostics for VNET. Within the Power Query Editor and transformation experience in Power Query Online and Dataflows, you can expect new transforms and capabilities to simplify your visual data prep in a visual authoring environment.

RSS Subscription Updates to data integration 2022 release wave 2

Investment areas

Investment areas

VNet data gateways
This feature allows enterprises that subscribe to VNet connectivity for their data services in Azure to seamlessly connect to Microsoft Power Platform using VNet data gateways.

Power Query connectors
Power Query connectors enable users to quickly connect to hundreds of applications, websites, databases, online services, and systems of record with the ease of low-code experiences. Every connector is built following Microsoft's best practices for seamless integration and use.

Dataflows
Dataflows provides a low-code self-service data preparation experience using Power Query, including orchestration, automation, and monitoring capabilities that enable users across Microsoft Power BI, Power Platform, Dynamics 365, and Azure to integrate data for downstream use by many other users and applications.

Power Query Online
Power Query Online is the data connectivity and data preparation experience for online users. This experience covers a wide variety of Microsoft products and services, including dataflows in Power BI, Power Platform, Dynamic 365 Insights Applications, and several more. For more information, go to Power Query.

Power Query Desktop
Power Query Desktop is the data connectivity and data preparation experience for desktop users. This experience covers a wide variety of products and services, including Power BI Desktop, Excel, SQL Server developer tools, and 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.