After you install August 9, 2016, update for Excel 2016 (KB3115438), the following data connectivity and transformation features are available in Excel 2016:
- Improved SAP HANA connector - Enable multi-select of values for variables or parameters.
- Improved OData connector - Add an option to import Open Type columns from OData feeds.
- Improved Access DB connector - Add the Select Related Tables button in the Navigator dialog box.
- Add an option to generate step names in English in the Query Editor.
- Description for query steps in the Query Editor.
- Extract week day and month name from a DateTime column.
- Merge dates and times into a single DateTime column.
- Extract start or end of an hour based on a DateTime column.