Plan and prepare for data integration in 2022 release wave 2
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.
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.
Updates to data integration 2022 release wave 2
Investment areas
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.
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.
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.