Plan and prepare for data integration in 2022 release wave 1

Important

The 2022 release wave 1 plan covers all new functionalities planned to be delivered to market from April 2022 to September 2022. 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 Data Cloud, enabling data connectivity, transformation, and integration across hundreds of critical enterprise cloud and on-premises data sources. Power Query enables users of Power BI, Excel, Power Apps, Insights Apps, and other Microsoft products and services to ingest and transform data from hundreds of sources.

In this upcoming release wave, we'll deliver improvements in our big data performance and high scale connectivity to Azure Synapse, Microsoft Dataverse, Snowflake, Databricks, BigQuery, and Redshift. You can expect several enhancements across connectors, gateway, and VNet. New capabilities will simplify data prep using the visual authoring environment and diagram view to create high-scale dataflows to Microsoft Cloud, supporting Power BI, Insights Apps, and Power Platform. We'll also deliver extract, transform, and load scenarios using Synapse Link to Dataverse, CosmosDB, and SQL.

Investment areas

Investment areas

Power Query connectors
The ability to connect to a wide range of different data sources is one of the core features of Power Query. In 2022 release wave 1, we're continuing to invest heavily in adding new data sources and expanding the reach of the existing sources into new applications, on the desktop and online.

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

Power Query Online
Power Query continues to be the primary data connectivity and data preparation experience for users across a wide variety of Microsoft products and services. For 2022 release wave 1, we'll continue to expand the scope of data sources available in Power Query and continue to add new features that provide an enhanced data preparation experience for users.

On-premises data gateway
The on-premises data gateway is a well-established product that's widely used by enterprises to access on-premises data sources and transfer petabytes of data weekly. Today, gateways are used either with one or a combination of services and applications, like Power BI, Power Apps, Power Automate, Azure Logic Apps, and others. Based on enterprise requests, we plan to continue to focus on making on-premises data gateways an enterprise-grade product with features like enhancements to load balancing, monitoring, and integration with additional services in the current milestone.

Azure Virtual Network data gateways
This feature provides the ability for enterprises who subscribe to Azure Virtual Network connectivity for their data services to use Microsoft Power Platform seamlessly.

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.