Forum Discussion
Dataflow runs for hours
Hello, I regularly have Gen2 dataflows that get stuck in refresh mode for hours on end, consuming all the resources of my capacity. Under normal circumstances, these dataflows only last a few minute...
I have the same issue trying to load from on-prem SQL Server with the latest gateway.
With a gen 1 dataflow, the table loads in a couple seconds. With gen2 and staging enabled, it takes a few minutes. Turning off staging, which I'd like to do since the query can fold, it takes an hour and a half and fails 9 out of 10 times.