Lakehouse SQL to Dataflow Keeps Failing

[JP8991]

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 occurred when receiving results from the server. (provider: TCP Provider error: 0 - An existing connection was forcibly closed by the remote host.)   It was working absolutely fine the other day and now it has stopped working and no changes have been made. Can anyone help me please?

@miguel

I created an identical Gen 2 Dataflow and that works fine as you can see from the below:

[miguel]

@JP8991  I've moved this topic to the Dataflow Gen1 forum as it's only happening in Gen1 Dataflows 

[JP8991]

@miguel can you move the whole thread as what has been moved provides no context of the problem.

[miguel]

Unfortunately, it appears that there was an error trying to move the whole thread, so I tried my best to edit your initial message to contain the same message that you had in your initial topic.

I'd highly recommend contacting support by creating a support ticket so they can take a closer look at this scenario. They might have the tools available to troubleshoot the issue or try to under better why the issue is happening. 

The error that you've shared is only telling us what's happening when the connection between the source and the dataflow is happening, but perhaps with the tools from the support team you could drill down into what specific error is happening at the Lakehouse level.