Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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.

1,977 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Josh Blackman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

303 comments

Attach a File
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Simon commented  ·   ·  Flag as inappropriate

    This should be ranked #1 above all other priorities. The performance is so terrible that it should almost be considered a bug.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Having to sit and wait for 10 minutes for a Power Query refresh is a drag (when it's just re-querying the same data repeatedly)! Please fix.

  • Will Golay commented  ·   ·  Flag as inappropriate

    Please keep high on priority list. It can take anywhere from 30-90 seconds to refresh a total of 100 rows separated into 15ish tables, far too long to be worth updating from the old legacy wizards for imports to the new OLE DB query connections.

  • UK_GER commented  ·   ·  Flag as inappropriate

    Pls. help us. Not all users have access to all Software (Power BI) in their companies.
    But still we spend hours because PQ is "like a drug".
    Decision makers from IT just wait to see us fail with "the toy" - and the door to P-BI starts to close before it opens.

    UK_GER

  • Imke Feldmann commented  ·   ·  Flag as inappropriate

    For recursive operations like an explosion of a Bill of materials table the performance difference between Power Query in Excel and PowerBI is vast: http://wp.me/p6lgsG-wV . Very hard to see what's possible in PowerBI with the same code that hopelessly fails in Excel. Please give us the power here as well!

  • Imke Feldmann commented  ·   ·  Flag as inappropriate

    I suspect there is more to the performance problems than shared nodes, but this would definitely be a good start! Full support from me.

  • Anonymous commented  ·   ·  Flag as inappropriate

    It is really a big issue. I have queries in my company which i have to start over night because of the time consumption...

  • Chris Higgins commented  ·   ·  Flag as inappropriate

    Agreed all around with refresh times. Could be internal server issues, but filtering and sorting when dealing with greater than 50K+ rows results in significant latency. In regards to display, when creating pivot tables, a more user friendly interface would be great when filtering between stacked pivot options (possible dropdown option on face of pivot). I would love to see an enhanced ability for excel to identify chronologies in pivot tables, i.e. when utilizing dates as headers, 1/15 would always be listed before 1/2. This would simply reduce the need for manual manipulation by users.

1 2 … 12 13 15

Excel for Windows (Desktop Application): Data Import

Feedback and Knowledge Base

(thinking…)