View Full Version : Power Query New Versions - How Do I Know?

2016-04-01, 06:51 AM
Are there resources / methods to learn
1) when a new version of Power Query is released
2) what's in the new Power Query release

For instance, PQ update 2.29.4217.1861 was released on Feb 23, 2016 without fanfare or documentation. The only thing that jumped out was 'Monospaced' font availability on 'View' menu.

Microsoft does not seem to advertise when updates become available or their feature set.

I usually wait until someone (like Ken Puls) writes about the update in a blog.

Thank you!

Ken Puls
2016-04-01, 04:27 PM
Hey there,

So yes and no. There isn't an easy way to point you to a page of recent updates, unfortunately. The best resource is the Microsoft Excel Blog (https://blogs.office.com/?filter=true&filter-product=excel), but that gets all kinds of stuff, so you have to basically watch for Power Query (Get & Transform) in the blog titles. Here is a link to the March 2016 update (https://blogs.office.com/2016/03/04/march-2016-updates-for-get-transform-in-excel-2016-and-the-power-query-add-in/).

The other option you have is to watch this page on Power BI Desktop (https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-latest-update/). This page is updated monthly and tends to be about 1-2 months ahead of Excel. (The main release schedule goes PBID first, then Excel.)

2016-04-01, 05:11 PM
Thanks, Ken. This is exactly what I needed. There are several new features which I had not noticed.

Your blog will be an excellent resource for these types of notifications.

My observation is that items such as 'Add prefix/suffix to a Text column' are already available using the 'M' language.
1) They now being simplified and exposed on the toolbar
2) Perhaps more clear examples in the Power Query Forumla Reference could explain simple but useful things like how to add a prefix to a column using the Table.TransformColumns function.
3) This would accelerate use of M instead of waiting for capabilities to appear in the Power Query toolbar

Ken Puls
2016-04-01, 09:56 PM
Honestly, all the "one click transformations" they add can already be done via the M language. They are building those to make it much easier to do.

Re the update notifications, I'll try to keep an eye on them. I missed the last blog post I think.

2016-04-04, 02:57 AM
I use this link, which searches the Excel blog for mentions of Power Query:


Ken Puls
2016-04-04, 04:50 PM
Good stuff, Mike. I think I'll add that to the main sticky thread on the subject. (And hopefully they don't drop the Power Query term any time soon.