November 8, 2016, update adds some new Get & Transform features in Excel 2016

S’applique à : Excel 2016

After you install MS16-133: Description of the security update for Excel 2016: November 8, 2016, the following data connectivity and transformation features are available in Excel 2016:
  • Oracle Connector – Improved Navigator Previews Performance.
  • OData Connector – Support for the Select Related Tables option.
  • SAP HANA Connector – Enhancements to parameter input UX.
  • Web Connector – UX Support for specifying HTTP Request Headers.
  • OData Connector – UX Support for multipart OData URLs.
  • Query Dependencies view.
  • Query Editor Ribbon Support for Scalar Values.
  • Add Function Invocation Column.
  • Expand & Aggregate Columns – Support for Load More values.
  • New Transform – Convert Table Column to a List.
  • Keyboarding – Support for smart typing in dropdown menus.