Publicacion y actualizacion de Flujo de Datos

[JELOMFER]

Muy buenas,

Tengo un flujo de Datos en la cual cargo 6 tablas diferentes de la misma base de datos SQL Server, hago las transformaciones en ellas, para dar como resultado dos tablas para cargarlas en un DataWarehouse. Me da el siguiente error en dos de ellas. En el Flujo no me da error en ninguna, A la hora de publicarlo tampoco me da error, es a la hora de actualizar cuando me da el error, en dos tablas, que stan hechas igual que las que dn coorrecta la actualización. ¿Me ayudan? El error es el siguiente:

SBOGESEME_RDR1: Código de error: Mashup Exception Data Source Error, Detalles del error: Couldn't refresh the entity because of an issue with the mashup document MashupException.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 = "cdzj27zwkvqude2667cipaw7ua-guuymy4p4mquzkbo2gsc37xcly.datawarehouse.fabric.microsoft.com;GESEME_Data_Lakehouse", 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.)"};ErrorCode = 10478;Microsoft.Data.Mashup.Error.Context = User GatewayObjectId: ab39d1ab-eca7-4f7b-aded-02b1e80f0a38 (Id. de solicitud: 30ab9ed8-72c5-4226-8a72-6af8114010b1).

[v-yilong-msft · Accepted solution]

Hi @JELOMFER ,

It seems that you are having problems updating tables in your data warehouse.

The error you mentioned “Mashup Exception Data Source Error” is usually related to connection or configuration issues in SQL Server. So I think you can do these steps below.

1. Make sure that the connection between the SQL Server and DataWarehouse is stable. This error indicates that the remote host is closing the connection, which could be a temporary network issue or a problem with the SQL server.

2. Check the privacy settings in Power BI or the service being used. Make sure the privacy level is the same for all data sources, preferably set to the “Organization” level.

You can read this topic below:

Solved: Error message on refresh- Microsoft.Data.Mashup.Ma... - Microsoft Fabric Community

3. Ensure that conversions applied to tables do not introduce errors. Sometimes complex conversions can cause problems during the update process.

Here is a topic you can refer:

Solved: Couldn't refresh the entity because of an issue wi... - Microsoft Fabric Community

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.