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 to the transformations but simply loading it into an excel workbook.
One of the datasets I am working with only has 238 rows, and when a refresh my Excel Workbook's data, it just shows 238 rows loaded for incredibly long without actually updating the worksheet. The query previews in query editor load relatively quickly, so I assume this is an Excel issue. Any tips would be greatly appreciated.
2 Replies
- 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.
