4 updates in Power Query for Excel

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.

Download Power Query image

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.

4 updates in Power Query for Excel Aug 1

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.

4 updates in Power Query for Excel Aug 2

4 updates in Power Query for Excel Aug 3

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.

4 updates in Power Query for Excel Aug 4

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.

4 updates in Power Query for Excel Aug 5

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.

Download Power Query image

—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.

Download the add-in and learn more about getting started.

Learn about all the powerful analytics and visualization features in Excel and take your analysis further by sharing and collaborating on business insights with colleagues using Power BI.