Good day.

I have filtered queries that merge into a single query. The end result in Excel is about 20,000 rows. When refreshing, it counts up to 3.6 million rows.

This is problematic for speed – but I cannot figure out where to determine the problem spot. I say “problem” because the query loads about 20,000 rows per second until about 3.1 million rows…then slows to about 100 rows per second until about 3.4 million when the speed returns to about 20,000 per second.

Questions:

– When refreshing a query (or in the preview mode in the Power Query Editor), what is the “Rows Loaded” actually counting?     [[If I have filtered rows, why does it count so many more?]]

– What would explain the variable speeds in refreshing?

– How can I trouble shoot to find what is slowing refresh?

– Should I change how I think about this in any way?

Thank you for any help.

​Good day. I have filtered queries that merge into a single query. The end result in Excel is about 20,000 rows. When refreshing, it counts up to 3.6 million rows. This is problematic for speed – but I cannot figure out where to determine the problem spot. I say “problem” because the query loads about 20,000 rows per second until about 3.1 million rows…then slows to about 100 rows per second until about 3.4 million when the speed returns to about 20,000 per second. Questions:- When refreshing a query (or in the preview mode in the Power Query Editor), what is the “Rows Loaded” actually counting?     [[If I have filtered rows, why does it count so many more?]]- What would explain the variable speeds in refreshing?- How can I trouble shoot to find what is slowing refresh?- Should I change how I think about this in any way? Thank you for any help.  Read More

​