What's new and planned for data integration
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
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.
- For a list of the previous wave's release plans, go to 2020 release wave 1 plan.
- For a list of the next wave's release plans, go to 2021 release wave 1 plan.
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 has two key objectives – providing a platform that allows partners and customers to develop connectors.
Feature | Enabled for | Public preview | General availability |
---|---|---|---|
Use the Microsoft Excel Online connector in Power Apps | Admins, makers, marketers, or analysts, automatically | Mar 31, 2021 | |
Stronger integration of the open source repository with custom connectors | Admins, makers, marketers, or analysts, automatically | - | Jan 7, 2021 |
Telemetry for certified connectors | Admins, makers, marketers, or analysts, automatically | - | Jan 13, 2021 |
More certified and custom connectors in our open source repository | Admins, makers, marketers, or analysts, automatically | - | Mar 31, 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 17, 2021 | - |
Improved save and validation experience for dataflows | Admins, makers, marketers, or analysts, automatically | Mar 17, 2021 | |
Integration with Dynamics 365 Customer Insights | Admins, makers, marketers, or analysts, automatically | Mar 17, 2021 | - |
Rename analytical dataflows | Admins, makers, marketers, or analysts, automatically | Mar 17, 2021 | - |
Microsoft Power Platform gateway
On-premises data gateway.
Feature | Enabled for | Public preview | General availability |
---|---|---|---|
Support for Kerberos SSO for Hive LLAP in Power BI | Admins, makers, marketers, or analysts, automatically | Feb 28, 2021 | |
Data source management enhancements | Admins, makers, marketers, or analysts, automatically | Mar 16, 2021 | |
Support for OAuth and Azure Active Directory authentication | Admins, makers, marketers, or analysts, automatically | - | Oct 31, 2020 |
Diagnostics for single sign-on data sources | Admins, makers, marketers, or analysts, automatically | - | Mar 16, 2021 |
Power BI refresh using the dataset owner's UPN | Admins, makers, marketers, or analysts, automatically | - | Mar 16, 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 |
Salesforce connector API upgrade for Power Query Desktop | Admins, makers, marketers, or analysts, automatically | - | Dec 1, 2020 |
Parquet connector | Admins, makers, marketers, or analysts, automatically | - | Dec 15, 2020 |
Custom role support for Snowflake connector for Power Query Desktop | Admins, makers, marketers, or analysts, automatically | - | Feb 28, 2021 |
Automatic table detection from JSON | Admins, makers, marketers, or analysts, automatically | - | Mar 15, 2021 |
General availability of Text/CSV by example data extraction | Admins, makers, marketers, or analysts, automatically | - | Mar 15, 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 |
---|---|---|---|
Query diagnostics improvements | Admins, makers, marketers, or analysts, automatically | Jan 31, 2021 | - |
Automatic table detection from Excel files | Admins, makers, marketers, or analysts, automatically | Mar 15, 2021 | |
Automatic table detection from JSON files | Admins, makers, marketers, or analysts, automatically | Mar 15, 2021 | |
Drag-and-drop support for managing query steps in the Steps pane | Admins, makers, marketers, or analysts, automatically | Mar 23, 2021 | |
FHIR connector in Power Query Online and dataflows | Users, automatically | - | Oct 31, 2020 |
Salesforce connector API upgrade for Power Query Online | Admins, makers, marketers, or analysts, automatically | - | Dec 1, 2020 |
Step icons within the Applied Steps pane | Admins, makers, marketers, or analysts, automatically | - | Dec 18, 2020 |
Azure Data Lake Storage support for Common Data Model folder view | Admins, makers, marketers, or analysts, automatically | - | Feb 1, 2021 |
In-product links to documentation | Admins, makers, marketers, or analysts, automatically | - | Feb 1, 2021 |
Key query indicators and actions in the status bar | Admins, makers, marketers, or analysts, automatically | Jan 31, 2021 | Feb 1, 2021 |
Fuzzy matching enhancements when grouping, clustering, and merging | Admins, makers, marketers, or analysts, automatically | Mar 1, 2021 | Mar 1, 2021 |
Advanced options for extracting text using delimiters | Admins, makers, marketers, or analysts, automatically | Mar 16, 2021 | Mar 16, 2021 |
Diagram view for authoring | Admins, makers, marketers, or analysts, automatically | Nov 12, 2020 | Mar 18, 2021 |
General availability of visual data prep for authoring within Power Query Online | Admins, makers, marketers, or analysts, automatically | Nov 12, 2020 | Mar 18, 2021 |
Global keyboard shortcuts | Admins, makers, marketers, or analysts, automatically | - | Mar 19, 2021 |
Custom role support for Snowflake connector for Power Query Online | Admins, makers, marketers, or analysts, automatically | - | Mar 31, 2021 |
Help tab in the Power Query ribbon | Admins, makers, marketers, or analysts, automatically | - | Mar 31, 2021 |
Power Query connector improvements | Users, automatically | - | Mar 31, 2021 |
Warnings for query changes in M authoring surfaces on user commit | Admins, makers, marketers, or analysts, automatically | - | Mar 31, 2021 |
VNet connectivity for Microsoft Power Platform
This feature provides the ability for enterprises who subscribe to VNet connectivity in Azure to use Microsoft Power Platform seamlessly.
Feature | Enabled for | Public preview | General availability |
---|---|---|---|
VNet connectivity for Power BI Premium datasets | Admins, makers, marketers, or analysts, automatically | Mar 2, 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.