August 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 eight new data transformation and connectivity features that have been requested by many customers.

 

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 and transformation features:
• Enhanced SAP HANA connector—allow multi-select of values for variables and parameters.
• Enhanced OData connector—option to import Open Type columns from OData feeds.
• Enhanced Access DB connector—new Select Related Tables button to “” in the Navigator dialog.
• Option to generate Step Names in English within the Query Editor.
• Description for Query Steps within the Query Editor.
• Extract Week, Day or Month name from a Date/Time column from the Query Editor.
• Merge Dates and Times into a Date/Time column from the Query Editor.
• Extract Start/End of Hour from a Date/Time or Time column from the Query Editor.

 

Read more details about each update on Office Blogs.