We are intermittently experiencing Timeout Expired Errors while DataSet Refresh.
The above Error observed on May 12, May 16, June 8, June 16, July 15, July 16, July 20, July 25 2022
When run in next refresh cycle the refresh is successful.
Also tried to replicate the issue by modifying the power queries used to refresh to query during specific timeperiods the issue was observed. When refreshed from Power BI Desktop observed no issues and refresh happens in less than minute.
Need help in finding root cause of the issue and next steps to mitigate the issue.
Sample Error :
An error occurred while processing the data in the dataset.
AzD has failed to refresh. Failure details: Timeout expired. The timeout period elapsed prior to completion of the operation.
Next refresh for AzD is scheduled for July 25, 2022 18:00 UTC.