Forum Discussion
Anonymous
4 years agoNot applicable
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...
amitchandak
4 years agoSuper User
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