Microsoft today aounced 12 new data transformation and coectivity features for Get & Transform in Excel 2016. If you have Office 365 subscription, you can get this update for free. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.
New or improved data coectivity and transformation features:
- New SAP HANA coector.
- New SharePoint Folder coector.
- New Online Services coectors category.
- Improved DB2 coector, now leveraging the Microsoft driver for IBM DB2.
- Improved Text/CSV coector, now exposing editable settings in the preview dialog.
- Improved relational database coectors, now including Schema information as a part of the Navigation hierarchy.
- Data Source Settings enhancements, including “Change Source” capability.
- Advanced Filter Rows dialog mode within the Query Editor.
- Inline Input controls for Function invocation within the Query Editor.
- Support for reordering Query Steps within the Query Editor by using drag and drop gestures.
- Date picker support for input Date values in Filter Rows and Conditional Columns dialogs.
- New context menu entry to create new queries from the Queries pane within the Query Editor.
Read about these features detail here.