What's new and planned for data integration
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.
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 connectors
The connector platform provides a rich set of connectors for customers and allows partners and customers to 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 |
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 |
|---|---|---|---|
| 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 20, 2021 |
| Amazon Redshift connector support for Azure AD SSO | Admins, makers, marketers, or analysts, automatically | - |
Sep 20, 2021 |
| Amazon Redshift connector support for native query | Admins, makers, marketers, or analysts, automatically | - |
Sep 20, 2021 |
| Dataverse connector support for native query | Admins, makers, marketers, or analysts, automatically | - |
Sep 20, 2021 |
| Google BigQuery connector native query support | Admins, makers, marketers, or analysts, automatically | - |
Sep 20, 2021 |
| Kerberos-based single sign-on through the on-premises data gateway for the Hive LLAP connector | Users, automatically | - |
Sep 20, 2021 |
| Navigator performance improvements for Snowflake connector | Admins, makers, marketers, or analysts, automatically | - |
Sep 20, 2021 |
| Updating Google Analytics connector to use Google Analytics API V4 | Admins, makers, marketers, or analysts, automatically | - |
Sep 20, 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 |
|---|---|---|---|
| Load data from a local file without using a gateway | Admins, makers, marketers, or analysts, automatically |
Sep 20, 2021 |
|
| Performance improvements for Power Query | Admins, makers, marketers, or analysts, automatically |
Sep 20, 2021 |
|
| Power Query Get Data experience improvements | Admins, makers, marketers, or analysts, automatically |
Sep 20, 2021 |
|
| Text/CSV data extraction using examples | Admins, makers, marketers, or analysts, automatically |
Sep 20, 2021 |
- |
| Custom column enhancements to specify column type | Admins, makers, marketers, or analysts, automatically | - |
Sep 20, 2021 |
| Gateways support for non-admin users | Admins, makers, marketers, or analysts, automatically | - |
Sep 21, 2021 |
VNet connectivity for Microsoft Power Platform
Enterprises that subscribe to Azure VNets can secure their data services and connect to Microsoft Power Platform seamlessly using VNet data gateways.
| Feature | Enabled for | Public preview | General availability |
|---|---|---|---|
| Virtual Network connectivity for Microsoft Power Platform dataflows | Admins, makers, marketers, or analysts, automatically |
Aug 3, 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.