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.

​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.    Read More

​