Query stalling at a specific row count?

[Anonymous]

Hi - when I'm refreshing my data model the main fact table (2.5M rows) hits a specific number of rows it stops pulling in data for 10-20 minutes, but starts again afterwards. This is the only query in the model that exhibits this behavior, all the other ones pull in all the data seamlessly. The query has quite a few of transformations, as well as 1 merge from another large table (~3M rows).

I'd love for any suggestions to help with this - thanks in advance~ 

[amitchandak]

@Anonymous , power query transformation can take time. Check if the merge column join is on text columns can it be done using the number data type column?

Remove any unnecessary steps

Also can that merge be moved at source, so that you do not have perform it at power query

[Anonymous]

Hi - I'm not able to move any of the transformations to the source. 

The merge column is currently text - but I could try and adapt it to a number format. I'm using a delimitor to join a couple of different values which functions as a lookup to a separate table. 

[Watsky]

Hiya @Anonymous to add to @amitchandak it would be helpful if you could screenshot your applied steps so we can see if there is anything that can be modified.

[Anonymous]

Hi - I posted the steps in the query above; I appreciate the help!