The timeout period elapsed prior to completion of the operation - How to identify the query?

[Anonymous]

Hello Dear PBI Users.

Upon trying to refresh the dataset on PBI service, I am facing the below issue:

"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

From my understanding , it is taking too long to load a data from a specific source. I have SQL, xlsx and Snowflake data mixed into the report and would like to know which table is having issues so I can troubleshoot it.

Unfortunately the error does not provide any indication what query is causing the issue, would anyone know how to find this information?

Thank you in advance,

[amitchandak]

@Anonymous , Can you refresh tables one by one and check which one is causing that ?

You can increase query time out

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

For sql server and snowflake clear data source permission and try again

[Anonymous · Accepted solution]

Hello @amitchandak , good morning.

Yes, in the end I did that to identify the faulty table, but I hoped there was a better way to find it.

Thank you anyways.