Forum Discussion

JP8991's avatar
JP8991
Kudo Commander
2 years ago

Lakehouse SQL to Dataflow Keeps Failing

Hello,   For the last few days I am getting a failed Gen 1 Dataflow when returning a table from an SQL table in my Fabric Lakehouse.   DataSource.Error: Microsoft SQL: A transport-level error has...
Dataflows
Need Help
v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi JP8991 

 

Thanks for using Microsoft Fabric Community.

The error "DataSource.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.)" in Microsoft Fabric indicates an issue with the connection between your application and the SQL Server.

 

Network Issues: Temporary network glitches, firewall restrictions, or overloaded routers can disrupt communication. SQL Server Issues: The SQL Server itself might be overloaded, experiencing software bugs, or configured incorrectly. TLS Mismatch: Outdated client-side libraries or server-side configurations that don't support the required TLS (Transport Layer Security) version can cause connection issues.

For more details please refer : An existing connection was forcibly closed by the remote host.

 

If the issue still persists, please do let us know. Glad to help.

 

I hope this information helps.

 

Thank you.