Summary of what's new in data integration

Improvements to this platform functionality enable richer connectivity to Microsoft and third-party applications and services.

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.

Power BI

Features Release type Date
New and Improved Connectors General Availability October 31, 2018
Support for certified custom connectors in Get Data experience General Availability October 2018
Improved Custom Connector development documentation including content for ODBC developers General Availability October 2018
New PDF Connector Public Preview September 11, 2018
“Fuzzy Merge” Transformation Public Preview October 15, 2018
AtScale connector Public Preview December 2018
Essbase connector Public Preview December 2018

On-premises Data Gateway

Features Release type Date
Support for custom connectors in the personal and enterprise gateway General Availability August 24, 2018
Guarantee high availability of gateways via clustering General Availability May 30, 2018
Improved Kerberos single sign-on support General Availability July 26, 2018
Improved data sources settings experience General Availability October 8, 2018
Ability to manage all the tenant’s gateways in the D365 admin portal Public Preview December 2018
Traffic load balancing in the on-premises data gateway Public Preview July 26, 2018

CDS for Apps and Power BI dataflows

Features Release type Date
Scheduled Refresh support for Data Integration projects in PowerApps Maker Portal General Availability August 31, 2018
GDPR (Ability to export user data, ability to audit all CRUD operations by a user, DPIA document) General Availability October 31, 2018
Improvements for Data Integrator Admins - improved review of historical records (pagination in execution history) General Availability November 2018
Support for File Upload (Blank Table) as part of File Connector experiences Public Preview October 15, 2018
Ability to browse OneDrive Business files Public Preview October 22, 2018
Support for top enterprise relational connectors (including Oracle database, IBM DB2 database and PostgreSQL) Public Preview August 31, 2018
Support for in-lake Data Transformations Public Preview November 2018
Centralized setup experience for DI (prevent switch between maker/admin portals) Public Preview November 2018
Performance improvements including data and batch parallelism Public Preview November 2018
Ability to cancel running execution  Public Preview October 1, 2018
Improved documentation including troubleshooting guidelines Public Preview November 2018
Ability to share projects within tenant Public Preview November 6, 2018
Richer dashboard with meaningful insights from integration data and additional integration related stats Public Preview March 2019
Automatic relationship creation between entities through Data Integration when the source entities are related Public Preview August 31, 2018

Microsoft Flow and PowerApps

Features Release type Date
Use sample data in triggers for top connectors General Availability October 31, 2018
Improved connectors: Oracle Database and MQ General Availability October 31, 2018
Support for built-in keys for Microsoft Translator, Bing Search and Bing Maps General Availability October 31, 2018
Support for new regions: Brazil General Availability October 31, 2018
Support for new regions: US Government (GCC) Public Preview January 2019
Support for policy templates in custom connectors Public Preview January 2019
Power Query support for reshaping data in Microsoft Flow (with the SQL Server connector) Public Preview September 24, 2018
Azure Data Factory Connector Public Preview April 30, 2018
New connectors: Dynamic Signal, Marketo, ElasticOCR, MailParser Public Preview May 31, 2018
New connectors PoliteMail and Cloud Connect Studio Public Preview June 30, 2018
New connectors ProjectWise Design Integration, LMS365, Azure IoT Central, and Survey123 Public Preview July 31, 2018
New connectors Power platform for Admins, PowerApps for App Makers, PowerApps for Admins, Microsoft Flow for Admins, Project Roadmap, NetDocuments, and Microsoft School Data Sync Public Preview August 31, 2018
New connectors: TeleSign SMS, AppsForOps, and K2 Workflow Public Preview September 30, 2018

Power Query

Features Release type Date
Community Website Launch General Availability February 2019
Data profiling capabilities to easily identify errors and outliers as part of the Data Preparation workload Public Preview October 15, 2018
Intellisense Support for M language Public Preview September 11, 2018

Connector Platform Extensibility

Features Release type Date
Consolidated connector certification program for partners to certify and release connectors for all products in the platform (Power BI, Microsoft Flow, PowerApps and CDS) General Availability October 30, 2018
Support for custom connectors using the Power Query SDK General Availability October 30, 2018
Improved development and validation tooling for M, OpenAPI and OData based connectors Public Preview October 30, 2018

Common Data Model

Features Release type Date
CDM GitHub repository where entity definitions open-sourced with additional documentation and tooling General Availability October 31, 2018
Improved CDM documentation explaining the value proposition and providing prescriptive guidance for building extensions General Availability October 31, 2018
Interactive, graphical Common Data Model entity explorer, with CDM GitHub enhancements General Availability October 31, 2018
Initial CDM entity packs for industry solutions such as healthcare, financial services, and retail Public Preview October 31, 2018
Additional CDM entity definitions covering key scenarios from popular Dynamics offerings including Finance, Operations, and Marketing Public Preview October 31, 2018