What's new and planned for data integration

This topic lists features that are planned to release from April 2021 through September 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 dataflows

Microsoft Power Platform dataflows provide a no-code experience for users to connect, transform, and enrich data from a wide variety of data sources.

Feature Enabled for Public preview General availability
Azure Synapse-based compute for dataflow tables in Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Sep 2021 -
Azure Synapse-based compute for Microsoft Dataverse tables in Dynamics 365 Customer Insights Admins, makers, marketers, or analysts, automatically Sep 2021 -
Duplicate dataflows in Microsoft Power Platform environments Admins, makers, marketers, or analysts, automatically - Sep 2021
New capabilities to support relational database integration with Microsoft Dataverse tables Admins, makers, marketers, or analysts, automatically - Sep 2021

Power Query connectors

Power Query connectors enable connectivity to hundreds of applications, websites, databases, online services, and systems of record with no code experience.

Feature Enabled for Public preview General availability
Support for Kerberos SSO for Hive LLAP in Power BI Admins, makers, marketers, or analysts, automatically Sep 2021
Snowflake connector native query support Admins, makers, marketers, or analysts, automatically - Jun 30, 2021
Adobe Analytics connector enhancements Admins, makers, marketers, or analysts, automatically - Sep 2021
Amazon Redshift connector support for Azure AD SSO Admins, makers, marketers, or analysts, automatically - Sep 2021
Amazon Redshift connector support for native query Admins, makers, marketers, or analysts, automatically - Sep 2021
Dataverse connector availability in dataflows Admins, makers, marketers, or analysts, automatically - Sep 2021
Dataverse connector availability in Excel Admins, makers, marketers, or analysts, automatically - Sep 2021
Dataverse connector support for multiple environments Admins, makers, marketers, or analysts, automatically - Sep 2021
Dataverse connector support for native query Admins, makers, marketers, or analysts, automatically - Sep 2021
Google BigQuery connector native query support Admins, makers, marketers, or analysts, automatically - Sep 2021
Kerberos-based single sign-on through the on-premises data gateway for the Hive LLAP connector Users, automatically - Sep 2021
Navigator performance improvements for Google BigQuery connector Admins, makers, marketers, or analysts, automatically - Sep 2021
Navigator performance improvements for Snowflake connector Admins, makers, marketers, or analysts, automatically - Sep 2021
Updating Google Analytics connector to use Google Analytics API V4 Admins, makers, marketers, or analysts, automatically - Sep 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.

Feature Enabled for Public preview General availability
Gateways support for non-admin users Admins, makers, marketers, or analysts, automatically Sep 2021
Load data from a local file without using a gateway Admins, makers, marketers, or analysts, automatically Sep 2021
Modify data used in Power BI reports created from manually entered data Admins, makers, marketers, or analysts, automatically Sep 2021
Performance improvements for Power Query Admins, makers, marketers, or analysts, automatically Sep 2021
Power Query Get Data experience improvements Admins, makers, marketers, or analysts, automatically Sep 2021
Use data from a CSV file when creating quick reports in Power BI Admins, makers, marketers, or analysts, automatically Sep 2021
Use data from a PDF file when creating quick reports in Power BI Online Admins, makers, marketers, or analysts, automatically Sep 2021
Use data from an Excel file when creating quick reports in Power BI Admins, makers, marketers, or analysts, automatically Sep 2021
Use Microsoft Dataverse data when creating quick reports in Power BI Online Admins, makers, marketers, or analysts, automatically Sep 2021
Custom column enhancements to specify column type Admins, makers, marketers, or analysts, automatically - Sep 2021
Text/CSV by example data extraction Admins, makers, marketers, or analysts, automatically - Sep 2021

Microsoft Power Platform connectors

The connector platform provides a rich set of connectors for customers and lets partners and customers develop connectors efficiently.

Feature Enabled for Public preview General availability
Independent publisher connectors Admins, makers, marketers, or analysts, automatically Jul 19, 2021 -
SAP ERP connector for Power Automate and Power Apps Users, automatically - Apr 30, 2021
Azure Active Directory support for Azure Blob Users, automatically - Jul 16, 2021
Support for custom code in connectors Users, automatically Aug 2, 2021 To be announced

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.