Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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.
@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
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |