Error when Pipeline refreshes semantic model

[julsr]

Hello everyone,

I have a semantic model in PowerBI.com that is refreshed by a Pipeline setting in Data Factory. The error is the following: DM_GWPipeline_Gateway_MashupDataAccessError.

This is the full error:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<ccon>Timeout expired. The timeout period elapsed prior to completion of the operation.</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"Timeout"}}],"exceptionCulprit":1}}} Table: Query1.

Does anyone have an idea of what could be wrong? It started today and sometimes succeeds but other times doesn't.

Thanks

[Anonymous · Accepted solution]

Hi @julsr ,

This error, DM_GWPipeline_Gateway_MashupDataAccessError, often indicates that the operation took too long to complete.

So I think you can try these steps below:

1. Review and optimize the queries in your semantic model to ensure they run efficiently. This might involve indexing, reducing the amount of data being processed, or simplifying complex queries.

2. Ensure that the gateway is not overloaded and has sufficient resources. Sometimes, restarting the gateway or the server where the gateway is installed can help.

3. Verify that there are no network issues between the data source and the gateway. Stable and fast network connectivity is crucial for timely data refreshes.

4. If possible, schedule the refresh during off-peak hours when the load on the data source and network is lower.

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.

[amitchandak]

@julsr , Seem like on-premise gateway is offline or not rechable

On Power Bi Service -> Setting icon (Right Top) -> Manage Connections and Gateways -> Check if the Gateway is up and running

Upgrate the gateway to latest version

Increase timeout.