April 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Excel 2016 includes a powerful new set of features based on Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

Today, we are pleased to announce two updates to this powerful feature set. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved Data Connectivity features:

  • ODBC Connector—Support for selecting User/System DSNs
  • CSV Connector—Ability to specify Column Delimiter in the Source dialog

ODBC Connector—Support for selecting User/System DSNs

A common request from customers using the ODBC Connector was being able to select from a list of available DSNs on their machine when specifying the connection details in the Import from ODBC wizard in Power Query in Excel.

With this update, we added a new drop-down menu so users can select an existing DSN from the list of available User/System DSNs on their machine. In addition to selecting an existing DSN, users can specify additional Connection String details or select “None” in the DSN drop-down to specify a full Connection String independently from any existing DSNs (equivalent to the behavior prior to this update).

Get and Transform April 1

CSV Connector—Ability to specify Column Delimiter in the Source dialog

We improved the Source dialog for the CSV Connector so that users can customize the Column Delimiter option. Before this update, the Column Delimiter option could only be modified via editing the underlying M formula for the Source step.

Get and Transform April 2

How do I get started?

Excel 2016 provides a powerful set of capabilities for fast, easy data gathering and shaping, which is available under the Get & Transform section on the Data ribbon. Updates outlined in this blog are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

—The Excel team