Transport-level Error using Dataflows Gen2

[AnthonyGenovese]

We are starting to receive the following error when running a dataflow gen 2 to the from on prem SQL Server to the lakehouse.

Mashup Exception Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Error in replacing table's content with new data in a version: #{0}. Details: [DataSourceKind = "SQL", DataSourcePath = "XXX", 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] GatewayObjectId: 0e14aac5-92c6-427b-94de-99eb9fb12b12

[miguel]

Hi!

This error is typically thrown by SQL Server when there's a firewall issue happening at one point. It would be something between your network and the service itself.

Could you please review the article below and let us know if it helps?

On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | ...

[AnthonyGenovese]

We have already solved for the firewall issue in June/July. I have confirmed we can connect to the sql endpoint just fine.