Forum Discussion
Transport-level Error using Dataflows Gen2
I’m also experiencing a similar issue when running Dataflows Gen2, but in my case, the data is being moved from a PostgreSQL server (cloud-hosted) to a Lakehouse in Microsoft Fabric. The on-prem component is the gateway connector. If the Lakehouse is open while the Dataflow is refreshing everything works fine, if not I get a similar error:
Mashup Exception Data Source Error: Couldn't refresh the entity because of an issue with the mashup document.
MashupException.Error: Microsoft SQL: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Details:
Reason = DataSource.Error;
DataSourceKind = Lakehouse;
DataSourcePath = Lakehouse;
Message = A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.);
ErrorCode = -2146232060;
Number = 10054;
Class = 20;
State = 0;
Microsoft.Data.Mashup.Error.Context = System;
GatewayObjectId: