Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Query stalling at a specific row count?

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~ 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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

    • Watsky's avatar
      Watsky
      Solution Sage
      4 years ago

      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's avatar
        Anonymous
        Not applicable
        4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.