Forum Discussion
"Transient Error" happening routinely
I have a fairly large power bi Semantic model on a scheduled refresh in Development, test and Production workspaces. The Production workspace is on a scheduled refresh to refresh roughly every 2 hours, while the development and test models refresh 1x per day (overnight). They routinely fail overnight, and occassionally the production model fails during the day as well. Here are the details. Can anyone help me determine why this is?
Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 06f17d3f-93bb-48dc-be10-85ae152b1a63
Request ID: 8daca50b-26b1-409e-b3e4-9778b7e84657
Time: 2024-12-23 06:03:10Z
Data source 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":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dw.cgtc.com;DW"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"0"}}],"exceptionCulprit":1}}}
2 Replies
Thanks for lbendlin's concern about this issue.
Hi, Pfutch1
Based on the information you provided, your Power BI model is experiencing a timeout issue when refreshing. Here are some possible causes and solutions:
The error message “Execution Timeout Expired” indicates that the query is taking too long to execute. You can try to optimize the SQL query to reduce the execution time or create indexes for the database tables.
Make sure your local data gateway is up-to-date and has enough resources. Sometimes increasing the gateway's memory or CPU allocation can resolve performance issues.
Check for network latency or connectivity issues between the Power BI service and the SQL server. Consistent network performance is critical for successful data refreshes.
Large amounts of data can cause timeouts. You might consider breaking data into smaller chunks or using incremental refreshes to manage large data sets more efficiently.
If multiple refresh tasks are running at the same time, this can lead to resource contention. Staggered refresh schedules may help alleviate this problem.
Ensure that your SQL server is configured to handle the load, including checking maximum server memory settings, query timeout settings, and making sure that the server is not overcommitted by other processes.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- lbendlin
Super User
As the error message states - your SQL server is too weak.
