Forum Discussion
January 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in
Excel 2016 includes a powerful set of features based on the 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, The Excel Team is pleased to announce six 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:
- New OLE DB connector.
- Enhanced “Combine Binaries” experience when importing from any folder.
- Maximize/Restore buttons in the Navigator and Query Dependencies dialogs.
- Support for percentage data type.
- Improved “Function Authoring” experience.
- Improved performance for OData connector.
To learn more about each of these features, please visit Office Blogs.
3 Replies
Hi Maddie
Just wondering if you know, or can find out when this bug with Get and Transform, which was introduced in FRDC 1701 (so I assume with this feature update) is going to be fixed?
I know a fix is already being tested since Insider 1704. We just need assurances that if it tests out ok, it's going to be backported to 1701. Our majority userbase must adopt DC 1701 in June as we've been unable to adopt 1609 due to an Outlook bug, so are stuck on DC 1605 which runs out of support next month. We can't however adopt 1701 if this Get and Transform bug has not been resolved. Yes, there is a mitigation but it's unworkable given the size of our organisation.
We've got a case open for Premier with this but they're struggling to get a response from the PG.
Thanks!
- D'oh, yes, forgot to include the hyperlink... thanks Martin!
