After you install August 8, 2017, update for Excel 2016 (KB3085435), the following Get & Transform features are available in Microsoft Excel 2016:
- Improves the Add Column From Examples features: suggestions, more Date/Time operations, additional transformations, support for additional number, date, time, and time zone transformations.
- New connector for Azure Data Lack Store.