Forum Discussion
Continued ContributorError when Pipeline refreshes semantic model
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
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.
2 Replies
- amitchandak
Super User
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.
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.
