New features for Get & Transform in Excel 2016 and Power Query add-in boost data transformation and connectivity

May 18, 2017   |   Deborah Bach

Three new data transformation and connectivity features requested by many customers are now available for the Get & Transform section and the Power Query add-in for Excel 2016.

The updates include automatic detection and population of the delimiter field in Query Editor, the ability to use sample files from folders to select objects and specify custom transformation steps in the Combine Files experience, and the option to specify the package collection to connect to within a DB2 server.

Head over to Office Blogs to learn more about the new features.

Deborah Bach
Microsoft News Center Staff