What's new and planned for data integration

This topic lists features that are planned to release from October 2020 through March 2021. 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.

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.

Microsoft Power Platform connectors

A critical part of data integration and the suite of products it supports—Power Apps, Power Automate, Power BI, and Power Query—is connectivity to external data sources. The connector platform has two key objectives: providing a platform that allows partners and customers to develop connectors efficiently, and providing a rich set of connectors for customers.

Feature Enabled for Public preview General availability
Telemetry for certified connectors Admins, makers, marketers, or analysts, automatically Nov 2020 -
Service principal support for SQL Server Admins, makers, marketers, or analysts, automatically Mar 2021
Use the Microsoft Excel Online connector in Power Apps Admins, makers, marketers, or analysts, automatically Mar 2021
Stronger integration of the open source repository with custom connectors Admins, makers, marketers, or analysts, automatically - Dec 2020
Feedback for certified connectors Admins, makers, marketers, or analysts, automatically - Mar 2021
More certified and custom connectors in our open source repository Admins, makers, marketers, or analysts, automatically - Mar 2021
Provide in-product guidance when connectors and operators are deprecated Admins, makers, marketers, or analysts, automatically - Mar 2021
SAP ERP connector for Power Apps and Power Automate Admins, makers, marketers, or analysts, automatically - Mar 2021
User interface within the Connector Certification Portal to add authors Admins, makers, marketers, or analysts, automatically - Mar 2021

Microsoft Power Platform dataflows

Microsoft Power Platform dataflows provide a no-code experience based on Power Query Online for non-technical users to connect, transform, and enrich data from a wide variety of data sources into Microsoft Dataverse and Azure Data Lake Storage in Common Data Model format.

Feature Enabled for Public preview General availability
Azure Synapse-based compute for Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Mar 2021 -
Improved save and validation experience for dataflows Admins, makers, marketers, or analysts, automatically Mar 2021
Integration with Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Mar 2021 -
Rename analytical dataflows Admins, makers, marketers, or analysts, automatically Mar 2021 -
Support for loading data to more Microsoft Dataverse data types Admins, makers, marketers, or analysts, automatically Mar 2021 -
Support for saving analytical dataflow data in Parquet file format Admins, makers, marketers, or analysts, automatically Mar 2021
Microsoft Power Platform dataflows connector available in Excel Admins, makers, marketers, or analysts, automatically - Mar 2021

Microsoft Power Platform gateway

On-premises data gateway.

Feature Enabled for Public preview General availability
Data source management enhancements Admins, makers, marketers, or analysts, automatically Mar 2021
Diagnostics for single sign-on data sources Admins, makers, marketers, or analysts, automatically Mar 2021 -
Gateway diagnosability Users by admins, makers, or analysts Mar 2021
Support for OAuth and Azure Active Directory authentication Admins, makers, marketers, or analysts, automatically - Oct 31, 2020
Power BI refresh using the dataset owner's UPN Admins, makers, marketers, or analysts, automatically - Mar 2021
Support for Kerberos SSO for Hive LLAP in Power BI Admins, makers, marketers, or analysts, automatically - Mar 2021

Power Query Desktop

Power Query 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 several more.

Feature Enabled for Public preview General availability
Hive LLAP Admins, makers, marketers, or analysts, automatically Mar 9, 2020 Nov 30, 2020
Adobe Analytics connector enhancements for Power Query Desktop Admins, makers, marketers, or analysts, automatically - Mar 2021
Automatic table detection from JSON Admins, makers, marketers, or analysts, automatically - Mar 2021
Automatic table detection in Excel files Admins, makers, marketers, or analysts, automatically - Mar 2021
General availability of Text/CSV by example data extraction Admins, makers, marketers, or analysts, automatically - Mar 2021
Impala connector enhancements for Power Query Desktop Admins, makers, marketers, or analysts, automatically - Mar 2021
Parquet connector Admins, makers, marketers, or analysts, automatically - Mar 2021
Salesforce connector API upgrade for Power Query Desktop Admins, makers, marketers, or analysts, automatically - Mar 2021
Snowflake connector enhancements for Power Query Desktop Admins, makers, marketers, or analysts, automatically - Mar 2021

Power Query Online

Power Query is the data connectivity and data preparation experience for users across a wide variety of Microsoft products and services, including Power BI, Excel, Customer Insights, and several more.

Feature Enabled for Public preview General availability
Advanced options for extracting text using delimiters Admins, makers, marketers, or analysts, automatically Mar 2021
Automatic table detection from Excel files Admins, makers, marketers, or analysts, automatically Mar 2021
Automatic table detection from JSON files Admins, makers, marketers, or analysts, automatically Mar 2021
Diagram view for authoring Admins, makers, marketers, or analysts, automatically Mar 2021
Drag-and-drop support for managing queries in the Queries pane Admins, makers, marketers, or analysts, automatically Mar 2021
Drag-and-drop support for managing query steps in the Steps pane Admins, makers, marketers, or analysts, automatically Mar 2021
Enhance the Power Query Get Data experience Admins, makers, marketers, or analysts, automatically Mar 2021
Fuzzy matching enhancements when grouping, clustering, and merging Admins, makers, marketers, or analysts, automatically Mar 2021
Key query indicators and actions in the status bar Admins, makers, marketers, or analysts, automatically Mar 2021
Load data from a local file without using a gateway Admins, makers, marketers, or analysts, automatically Mar 2021
Text/CSV by example data extraction Admins, makers, marketers, or analysts, automatically Mar 2021
FHIR connector in Power Query Online and dataflows Users, automatically - Oct 31, 2020
Adobe Analytics connector enhancements for Power Query Online Admins, makers, marketers, or analysts, automatically - Mar 2021
Azure Data Lake Storage support for Common Data Model folder view Admins, makers, marketers, or analysts, automatically - Mar 2021
General availability of visual data prep for authoring within Power Query Online Admins, makers, marketers, or analysts, automatically - Mar 2021
Global keyboard shortcuts Admins, makers, marketers, or analysts, automatically - Mar 2021
Help tab in the Power Query ribbon Admins, makers, marketers, or analysts, automatically - Mar 2021
Impala connector enhancements for Power Query Online Admins, makers, marketers, or analysts, automatically - Mar 2021
In-product links to documentation Admins, makers, marketers, or analysts, automatically - Mar 2021
Power Query connector improvements Users, automatically - Mar 2021
Salesforce connector API upgrade for Power Query Online Admins, makers, marketers, or analysts, automatically - Mar 2021
Snowflake connector enhancements for Power Query Online Admins, makers, marketers, or analysts, automatically - Mar 2021
Step icons within the Applied Steps pane Admins, makers, marketers, or analysts, automatically - Mar 2021

Virtual network connectivity for Microsoft Power Platform

This feature provides the ability for enterprises who subscribe to virtual network connectivity in Azure to use Microsoft Power Platform seamlessly.

Feature Enabled for Public preview General availability
Virtual network connectivity for Microsoft Power Platform Admins, makers, marketers, or analysts, automatically Mar 2021

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.