New version of Power Query released by Microsoft - Excelerator BI

New version of Power Query released by Microsoft

Microsoft has announced a new version of Power Query on the MSDN blog this week. There is a full decscription of the new features available at the following link, however I have provided a summary of the key features I am looking forward to.
Power Query

Features and Benefits

New Feature What it means to you
Improved connectivity to Excel Data in other workbooks It is now much easier to connect to named ranges and tables in other workbooks
Preserve custom formatting Previously when you refreshed the data into the worksheet all your formatting of that table was wiped out. This is now fixed.
Remove bottom rows This is now as easy as remove top rows. Previously this required a formula.
New stats features for columns Now you can add a new or custom column and use statistical formula (ie sum/avg etc) to create new data.
Change order of Queries This used to be a real pain. The order of the queries in the workbook was fixed and you couldn’t order them logically – eg in process step order. This is now fixed.

These are just some of the new features – there are many more. But these are the ones I like the most.

What do others think?

Power Query Online Training

If you want a comprehensive lesson on how to use Power Query, checkout my training course here

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top