This month’s Power Query update includes four new or improved features, including:
- Option to specify Join Type in the Merge Queries dialog.
- Extract first, last or range of characters from a Text column.
- Customize the Quote Style in Split Column by Delimiter dialog.
- Support for UPN credentials in the Exchange connector.
You can continue reading below for more details about each feature.
Option to specify Join Type in the Merge Queries dialog
It is now possible to specify the type of Join that you would like to apply when merging two queries using the Merge Queries dialog. These options were previously available only by manually modifying the generated formula. Now they are much more easily accessible in the Merge Queries dialog.
Extract first, last or range of characters from a Text column
With this update we have added user interface (UI) support to specify how many characters to extract from a Text column, starting from the beginning, end or a specific position. This new set of transformations can be found under the Text -> Extract Group in the Transform and Add Column tabs on the Query Editor ribbon.
Customize Quote Style in the Split Column by Delimiter dialog
Users can now switch between the CSV Quote Style and no Quote Style when splitting a column by delimiter. This option is available in the Advanced Options section of the Split Column by Delimiter dialog.
Support for UPN credentials in the Exchange connector
In this update, we added support for specifying a UPN (User Principal Name) as part of providing credentials to use the Exchange connector. This option is available from the Credentials prompt when using this connector. If you have already connected to Exchange before and need to modify your credentials, you can access this option from the Data Source Settings dialog.
That’s all for this month. We’re making lots of incremental improvements to Power Query and we hope that you find it better with every new monthly update. Please continue sending us feedback using our “Send a Smile/Frown” feature or by voting for what you’d like to see next.
—Miguel Llopis, program manager on the Power Query team
Power Query for Excel is available with an Office 365 ProPlus subscription, Office 2010 Professional Plus with Software Assurance, Office 2013 Professional Plus or Excel 2013 Standalone. Power Query for Excel is also available in all other Excel 2013 Desktop SKUs with reduced functionality. Check out the System Requirements section on this page for more details.
- Learn more about Power Query
- See all analytics and visualization features in Excel
- Get your Office 365 subscription
- Try Power BI
- Follow us: Facebook and Twitter
Source: Office Blog