OK, so supposedly out in late August but only across our desk now, we thought we ought to bring you up to speed on the latest features to the ever-improving Power Query (Excel 2010 and Excel 2013) / Get & Transform (Excel 2016). There’s eight of them in fact:

• 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 box
• 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.

We'll go through them in October's newsletter (if you are not already a subscriber, simply join up at the bottom of any of our web pages). In the meantime, you can find more details here or else drop us a line at contact@sumproduct.com.