- Enhanced SQL Server connector - Support for the SQL Failover option.
- New transform - Horizontal list expansion.
- ODBC and OLE DB connectors – Support the Select Related Tables function.
- Enhanced folder connector – Support the Combine function from the Preview dialog box.
- Unified text and CSV connectors.
- The Change Type Using Locale option on Column Headers Type menus.
- The Insert Step After option on the Steps pane.
After you install MS17-014: Description of the security update for Excel 2016: March 14, 2017 (KB3178673), the following Get & Transform features are available in Microsoft Excel 2016: