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.

http://blogs.msdn.com/b/powerbi/archive/2014/05/06/new-updates-for-power-query.aspx
Power Query

Features and Benefits
New FeatureWhat it means to you
Improved connectivity to Excel Data in other workbooksIt 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?

 

If you want a comprehensive lesson on how to use Power Query, checkout my training course here https://exceleratorbi.com.au/power-query-online-training/

Leave a Comment

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

Scroll to Top