What’s new and planned for Common Data Model and Data Integration
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 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 between April and September 2019. Previews for some features will start in February 2019.
These release notes describe functionality that may not have been released yet. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).
When a month is used in the Date column, the feature will be delivered sometime within that month. The delivery date can be any day within that month, not just on the first day of the month.
For a list of the countries or regions where Dynamics 365 business applications are available, see the International availability guide.
The April '19 release has four themes for these areas: Power Query, Connector Platform and Extensibility, Common Data Model (CDM), Dual Write (Link to Common Data Service for Apps), CDS Data Integrator, Data Export Service, Data Integration Templates, and Gateway.
Power Query Desktop
| Area | Feature | Release type | Date |
|---|---|---|---|
| New and enhanced connectors | We're working on connectors for PDF, Essbase, and IBM DB2 DirectQuery. |
General Availability |
April 2019 |
| New and enhanced connectors | We're adding a connector for AtScale. |
Public Preview |
April 2019 |
| New and enhanced data preparation capabilities | Based on customer feedback, we’ll improve "Smart Data Prep" Power Query Desktop features and make them generally available over the next six months. |
General Availability |
April 2019 |
| Connectivity Platform | We're adding support for developer-signed custom connectors. | Public Preview | April 2019 |
Power Query Online
| Area | Feature | Release type | Date |
|---|---|---|---|
| New and enhanced get data capabilities | We're making it possible to create tables by typing or copy-pasting data into Power Query Online and to browse OneDrive for Business when connecting to file sources in Power Query Online. | General Availability | April 2019 |
| SAP data connectivity | Support for modifying SAP HANA and BW variables in PowerBI.com for a published report. | Public Preview | June 2019 |
| New data connectors | We're working on new data connectors, including Amazon Redshift, Impala, Apache Spark, HDInsight Spark, HDInsight Hive Interactive Query, Vertica, Google BigQuery, Teradata, Informix, Sybase, MySQL, and PostgreSQL. | Public Preview | April 2019 |
| Fundamentals and compliance | Power Query Online support in new regions and GCC. | Public Preview | April 2019 |
| Mapping entities to CDM schema | Includes support for mapping to CDS for Apps data types when creating new entities via Power Query Online Data Integration and improved experiences for browsing entities when mapping entities to CDM schema. | Public Preview | April 2019 |
| Common Data Service for Apps | Includes support for lookup import using natural keys when creating new entities via Power Query Online Data Integration. | Public Preview | April 2019 |
Common Data Model
| Feature | Release type | Date |
|---|---|---|
| Updated documentation and quick-start guides for developing with the Common Data Model | General Availability | April 2019 |
| Extensions to CDM schema documents such as versioning | Public Preview | April 2019 |
| SDK and tooling in multiple languages for CDM schema documents, CDM folders, and model.json files | Public Preview | April 2019 |
| New CDM entity definitions covering key scenarios from popular Dynamics offerings, including Finance, Operations, and Marketing | Public Preview | April 2019 |
| CDM entity packs for industry solutions such as education, non-profit, and retail | Public Preview | April 2019 |
Dual Write
| Feature | Release type | Date |
|---|---|---|
| Frictionless experience that enables Dynamics 365 for Finance and Operations customers to natively get their data in Common Data Service | Public Preview | May 2019 |
| Ability to write initial data prior to turning on Dual Write | Public Preview | May 2019 |
| Making Dual Write resilient to planned or unplanned maintenance | Public Preview | May 2019 |
| Support for multiple legal entities in Dual Write | Public Preview | July 2019 |
CDS Data Integrator
| Feature | Release type | Date |
|---|---|---|
| Enhancements in Error handling and troubleshooting | Public Preview | April 2019 |
| Ability to propagate template updates to projects | Public Preview | June 2019 |
| Richer dashboard with meaningful insights and views | Public Preview | April 2019 |
| Guidance for performance tuning and integration write patterns | Public Preview | April 2019 |
| Compliance for government cloud | Public Preview | June 2019 |
Enable Common Data Service entities for analytics
| Feature | Release type | Date |
|---|---|---|
| Extract intelligence from your CDS data through first-party analytics apps | Public Preview | July 2019 |
| Frictionless experience to connect and hydrate your Azure Data Lake Storage | Public Preview | July 2019 |
| Support for initial and incremental writes | Public Preview | July 2019 |
| Support for data and metadata changes in Azure Data Lake | Public Preview | July 2019 |
Data Export Service
| Feature | Release type | Date |
|---|---|---|
| Show count of records from Dynamics 365 for Sales (CRM) and Azure SQL | General Availability | August 2019 |
| Show trend of records from Dynamics 365 for Sales (CRM) and Azure SQL | General Availability | August 2019 |
| Notifications on write failures | General Availability | August 2019 |
| Minimize write failures by prioritizing metadata before data | General Availability | August 2019 |
| Reduce latency and improve perf on processing deletes | General Availability | April 2019 |
| Show unsupported entities for change tracking | General Availability | April 2019 |
Data Integration templates
| Feature | Release type | Date |
|---|---|---|
| New templates and updating existing templates (Dynamics 365 for Finance and Operations, Field Service, Project Service, Dynamics 365 for Talent, and Salesforce) | General Availability | April 2019 |
Connector Platform and extensibility
| Feature | Release type | Date |
|---|---|---|
| New and enhanced connectors for PowerApps and Microsoft Flow | Public Preview | April 2019 |
| Rich documentation and guides for developing connectors | General Availability | April 2019 |
| Custom connector CLI for PowerApps and Microsoft Flow | Public Preview | April 2019 |
| Support for policy templates in custom connectors for PowerApps and Microsoft Flow | Public Preview | April 2019 |
| Open source connector development for PowerApps and Microsoft Flow | General Availability | April 2019 |
| Improved connector certification process | General Availability | April 2019 |
Gateway
| Feature | Release type | Date |
|---|---|---|
| OOTB certified data connectors support (Extensibility support) | Public Preview | April 2019 |
| Multiple credentials for an on-premises data source | General Availability | June 2019 |
| Gateway administration across a tenant | Public Preview | April 2019 |
| Gateway management enhancements | Public Preview | September 2019 |
| Improved reliability, supportability, and diagnostics | General Availability | April 2019 |
| SAP BW single sign-on (Kerberos) in Power BI Service (via On-premises data gateway), for SAP BW Application and Message Server | Public Preview | April 2019 |
| SAP HANA single sign-on (SAML) in Power BI Service (via on-premises data gateway) | Public Preview | April 2019 |