Skip to main content
Skip to main content
Microsoft 365

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.

You may also like these articles

Image for: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…