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
| 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?
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/
