Microsoft announces new features for Get & Transform in Excel 2016. It allows users to connect, combine, and refine data sources to meet their analysis needs.

Horizontal list expansion: With this update, they have made it easier to extract data values from a column containing nested lists. It is accessible via the column headers in a List column, or by using the Expand ribbon entry point.

Enhanced SQL Server connector: Support for SQL Failover option: They have improved the SQL Server connector and added a new option to enable SQL Server Failover support. This new option can be found under the Advanced Options section in the SQL Server connector dialog.

These updates are available for free as part of an Office 365 subscription.