PBI Service Refresh Fails -Error -Microsoft SQL: Execution Timeout Expired.

[PowerBIShan]

Hi all,

My source is Azure Synapse.I have configured Incremental refresh in PBI Desktop and published to Service. It was working fine .
But suddenly i am getting below error

Last refresh failed: 1/22/2023, 5:17:51 PM
There was an error when processing the data in the dataset.Hide details

Data source 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.\r\n111202;Query QID22470133 has been cancelled.\r\nOperation cancelled by user."}}],"exceptionCulprit":1}}}

When I try to check refreshing from PBI Desktop ,there is no issue and it refreshes without any error.
May i Know how to resolve this issue?
I tried increasing the Command Timeout to 30 mins in PBI Desktop and republishing it and checked in PBI Service.It still shows same error in service.Is there any other method i could solve this issue.

[GilbertQ]

Hi @PowerBIShan 

With the timeout error there could be a few issues. What I would suggest is checking how long it takes to refresh in PBI Desktop. ARe you using Power BI Pro license (which has got a 2 hour timeout on the query execution), or Power BI Premium Per user and Power BI Premium (Is a 5 hour query timeout)