After you install May 3, 2016, update for Excel 2016 (KB3115090), the following Data Connectivity features are available in the Get & Transform section of the Data ribbon in Excel 2016:
Supports command time-out for user experience.
Settings to disable Privacy Level prompts at the computer level (including the GlobalPrivacyLevel registry key).
Query group management:
- Expand or collapse all
- Keep query group expansion states
New transformations:
- Delete blanks on the Column Filter menu
- Convert duration values to Years
- Keep duplicates
Supports white space and line feeds in the Query Editor preview.
Includes hints for sample input values in the Change Type with Locale dialog box.
Navigator improvements:
- Ability to disable preview from the navigator
- Technical name support
Renames queries directly from the Queries pane.