Mashup.Error while trying to publish my Dataflow Gen2

[CrhIT]

I'm trying to publish a Dataflow2 saving the result into my datawarehouse however I always get the Mashup.Error. I followed the possible solutions in 

https://stackoverflow.com/questions/2962927/a-transport-level-error-has-occurred-when-receiving-resu...

https://community.fabric.microsoft.com/t5/Dataflows/Transport-level-Error-using-Dataflows-Gen2/m-p/3...

However none of those seems to help me. I even write a ticket and still got no response.

I pase the error downbelow

Sales: Error Code: FailedToInsertATable, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Failed to insert a table., InnerException: #{0}: #{1}, Underlying 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;Message = 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.);Detail = [DataSourceKind = "Lakehouse", DataSourcePath = "Lakehouse", DataSourceKind.2 = "SQL", DataSourcePath.2 = "p6qjrwhwccquje2v5pai6zxfve-spqg6ly32hje3cc3jfnircrvyi.datawarehouse.fabric.microsoft.com;DataflowsStagingLakehouse", 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];Message.Format = #{0}: #{1};Message.Parameters = {"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.)"};Microsoft.Data.Mashup.Error.Context = System (Request ID: 690d41fc-5ea2-4701-8287-35f2c83cb63f).

[CrhIT · Accepted solution]

If you facing this type of error, try disabling staging in Data flow Gen2 and organice your data flow to consume less resources.

[v-cboorla-msft]

Hi @CrhIT 

Glad that you were able to find some insights and thank you for sharing the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.

Thank you.

[v-cboorla-msft]

Hi @CrhIT 

Thanks for using Microsoft Fabric Community.

If you have opened a support ticket, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thank you.

[v-cboorla-msft]

Hi @CrhIT 

We haven’t heard from you on the last response, If you have opened a support ticket, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thank you.