Forum Discussion
Cannot refresh a Power BI Report
Hi Lorenz33 ,
I am sorry that I cannot reproduce your situation. It seems to me that in Power Bi Service not need to be adjusted, if it is due to a timeout setting in Power BI Service, it will simply report an error timeout instead of Processing was cancelled due to an interrupt. Related link below, there are the same users who encountered the same problem If you have the same problem, you can refer to the linked solution to change the DB2 timeout or disable timouts:
Best Regards
Lucien
Hi Lorenz33 ，
If the application sets a query timeout value, it will stop the execution of the statement if it exceeds the timeout resulting in a SQL0952N error.
And details solution to resolve the problem,refer the following links:
https://www.ibm.com/support/pages/sql0952n-error-returned-long-running-sql-statement
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Thanks Lucien. The attached article looks very helpful. Does anything need to be done on the Power BI Report Server side? The article explains to increase the query timeout interval on the different application types. Within Power BI Report Server I went to site settings and under report timeout I changed the value to 3660 seconds from 1800 to allow the report to run before timing out. This would be one hour and the scheduled refresh fails after 10 minutes.
Hi Lorenz33 ,
I am sorry that I cannot reproduce your situation. It seems to me that in Power Bi Service not need to be adjusted, if it is due to a timeout setting in Power BI Service, it will simply report an error timeout instead of Processing was cancelled due to an interrupt. Related link below, there are the same users who encountered the same problem If you have the same problem, you can refer to the linked solution to change the DB2 timeout or disable timouts:
Best Regards
Lucien