Forum Discussion
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 i...
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
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.
Hi - I posted the steps in the query above; I appreciate the help!