Power Query Update Available (as of Monday, July 25 2016)

dburke · Jul 25, 2016

Friends,

Power Query for Excel update available from Microsoft.

Name: PowerQuery_2.35.4399.761
Date Available: July 25, 2016
Features: https://goo.gl/nFW5Lb
Download: https://goo.gl/QWnKYV

New or improved features:

New SAP HANA connector.
New SharePoint Folder connector.
New Online Services connectors category.
Improved DB2 connector, now leveraging the Microsoft driver for IBM DB2.
Improved Text/CSV connector, now exposing editable settings in the preview dialog.
Improved relational database connectors, now including Schema information as a part of the Navigation hierarchy.
Data Source Settings enhancements, including “Change Source” capability.
Advanced Filter Rows dialog mode within the Query Editor.
Inline Input controls for Function invocation within the Query Editor.
Support for reordering Query Steps within the Query Editor by using drag and drop gestures.
Date picker support for input Date values in Filter Rows and Conditional Columns dialogs.
New context menu entry to create new queries from the Queries pane within the Query Editor.

PowerQuery_2.35.4399.761

linelson · Aug 21, 2016

Data Source Settings enhancements, including “Change Source” capability is good, but only the next update will add support for most other sources like files and folders.