Forum Discussion
Gen2 Dataflow to Warehouse - really slow performance
I am in the same boat as you. I think this all comes down to the write speed to the warehouse. Things just seem to lock up and time out. I can't even get 100k rows to write...
I watched the query against our on-prem sql server and noticed that it had a ASYNC_NETWORK_IO wait the whole time. According to MSFT docs, these are due to the client application (the warehouse) not accepting results fast enough.
I also noticed that the warehouse becomes unresponsive while the dataflow is running.
I can't imagine we are the only ones who are experiencing these issues. There must be some solution or acknoledgment if Fabric is now GA. I'm trying to sell Fabric to my org, but it's a bit hard when we can't get our data into it.
Here's my support ticket if it helps: 2311060040014961
Same boat here.
Cannot get the dataflows to write into the warehouse for the life of me.
Support ticket is this: 2311150050004676