After you install January 3, 2017, update for Excel 2016 (KB3141472), the following Get & Transform features are updated in Excel 2016:
- OData Connector: Folding of expanded record operations. This improves the import and refresh performance.
- Enhanced Combine Binaries experience: Now supports the ability to combine .xls and .xlsx files.
- Percentage data type: This is now supported.
- Maximize and Restore buttons in the Navigator and Query Dependencies dialog boxes: These are now supported.