Forum Discussion
Excel loading in a table from Power Query extremely slowly
I have a workbook that uses multiple queries, with lots of merges/joins. I know that this can slow down the data processing time a bit, however I am getting extremely slow query load times, not due t...
I am posing the same query. I hope that someone can provide me with an answer.
Power Query doesn't keep intermediate results. If you have "workbook that uses multiple queries, with lots of merges/joins" all of them will be evaluated from scratch when you return result into the grid. Even if resulting table has only one row.
In Preview mode some intermediate results could be taken from cache, thus looks as faster.
