What’s new and planned for Common Data Model and Data Integration

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 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 May 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 May 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