Timeout issues

[Anonymous]

We have been getting consistent timeouts refreshing models in our Premium Capacity. Sometimes the models refresh fine in just a few minutes, and other times they run until they hit the timeout threshold (in some cases over well over an hour). The errors we have been getting point to timeouts on the database (Azure SQL DB), however the DBA team has not been able to find any constraints from the database side. Also, none of our other BI tools have had similar timeout issues as Power BI. 

Is anyone else facing similar mysterious timeout issues?

Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

DataSource.Error: <pii>Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.</pii>.

[Anonymous]

Hi @Anonymous ,

Please refer to the following topic to see if it helps you.

https://community.powerbi.com/t5/Service/Refresh-Failed-Internal-Service-Error/m-p/381780

1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)

2 - Refresh the data in the desktop and save.

3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.

4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online

5 - Hop back to PBI Online and set the refresh schedule back up

6 - Add the reports back into any apps or content packs.

If it didn't help you, please contact me again.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.