Power Query - cache shared nodes
Update Power Query in Excel to take advantage of caching in cases where a parent node refers to a child node that has already been refreshed (as exists in Power BI desktop today).
This issue creates significant performance problems with refresh times when creating highly interdependent financial and operational models. This is a show stopper from a usability and customer acceptance standpoint.
We are happy to announce that the feature is finally available on Production starting from July fork (build 16.0.10726.*) for Office 365 subscribers.
Thank you all for your votes and the feedback.
- Excel Team
Slow refreshing sucks
I love Power Query.
My Power Query routines are getting more complex and handling larger data sets.
It would be very helpful to have faster query response time.
Anthony McRae commented
Consider my vote is done Ken.
Wyn Hopkins commented
Power Query is blowing users minds when they see it in action, refresh speed in Excel however can be unacceptably slow. Any improvements in this area would be greatly welcomed.