SQL Execution Timeout error reason

[rajulshah]

Hello everyone,

I am getting the following error:

"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","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."}}],"exceptionCulprit":1}}

Please help us decoding the error message. Can anyone guide us whether this error can be from the SQL or when it fetches the data in Power BI?

Any help would be great.

Thanks

[amitchandak · Accepted solution]

@rajulshah , Try increasing timeout

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459

[PhilipTreacy · Accepted solution]

Hi @rajulshah 

The query is taking longer than is allowed.  See here

https://community.powerbi.com/t5/Desktop/quot-Microsoft-SQL-Execution-Timeout-Expired/td-p/831355

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[amitchandak · Accepted solution]

@rajulshah , Try increasing timeout

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459