Forum Discussion

JP8991's avatar
JP8991
Kudo Commander
2 years ago

Re: 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 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:

 

Need Help

3 Replies

  • miguel's avatar
    miguel
    Community Admin
    2 years ago

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

    • JP8991's avatar
      JP8991
      Kudo Commander
      2 years ago

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

      • miguel's avatar
        miguel
        Community Admin
        2 years ago

        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.