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 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
|New and enhanced connectors||We're working on connectors for PDF, Essbase, and IBM DB2 DirectQuery.
|New and enhanced connectors||We're adding a connector for AtScale.
|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.
|Connectivity Platform||We're adding support for developer-signed custom connectors.||Public Preview||April 2019|
Power Query Online
|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
|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|
|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
|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
|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
|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
|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
|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|
|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|