Dataflow refresh failing with timeout error within 10mins or 30mins
I have a dataflow setup for a long time which refresh UK morning time. Over the last few days, the refresh is failing with strange timeout error. Yesterday, the refresh failed after 30mins, with the error below. The dataset on which the I got the error was only executing for 1min and 30.9secs.
Error: The operation is timed out. Request ID: a09e3682-e741-4535-883b-7960347285cf Activity ID: c9b7e823-5720-44da-ba80-4df20f802041
I manually started the refresh and it completed successfully.
Today again the refresh failed with the following error after 44mins. This time on a different dataset which was executing for 1mins and 30.6secs.
Error: The operation is timed out. Request ID: b8cd8430-cdaf-4cfd-88e9-94f69122f272 Activity ID: 0c3fc6f8-2ae3-4143-95d7-bfbfedbe97ef
I started a manual refresh and it failed with the following error after 10mins. this time failing on a third dataset which was executing for under 2mins.
Error: The operation is timed out. Request ID: c495e34f-65db-5cac-a7d1-a666dcedc1c0 Activity ID: dfef7704-dc81-4347-ab5e-e1e1b39885de
How do we findout where is the problem - is it a problem on the gateway or on the PowerBI service?
2 Comments
v-yingjlCommunity Support
Status changed:NewtoInvestigatingIf your dataflow is in the premium workspace, see this known issue document:
Known issue - Long running, failed or stuck dataflow in Premium Gen2
As a last resort, you can try swapping the workspace out of Premium to Pro and wait a few minutes. Then switch the workspace back to Premium. This solution may help to provide relief, but the issue could reoccur.
Information on the support page:
https://powerbi.microsoft.com/en-us/support/
Engineers have identified multiple root causes and expect a first improvement of the experience to be deployed by end-of-day 06/30/2022. A next major wave of fixes is expected to be deployed by end-of-day 07/21/2022.
Best Regards,
Community Support Team _ Yingjie LiCurrently, we have many refreshes that are hanging. I tried to restart the Premium Capacity to clear them out. However, the Advanced Setting is not available for me for some unknown reason.
I tried to use a direct URL to enable the Restart Button but got this error message.
Premium capacity error
If you contact support, please provide the technical details:
Activity ID005a2646-60f1-45d9-afd3-ba122fe98586
Correlation IDbf3cab99-0819-f5eb-3bbb-063b1c8c79c2
Request ID37699775-2349-5e6c-a542-3d5110450776
TimeThu Nov 10 2022 07:31:26 GMT-0600 (Central Standard Time)
Service version13.0.19403.8
Client version2210.5.10743-train
Cluster URIhttps://wabi-us-north-central-g-primary-redirect.analysis.windows.net/
it related about this issue?
regards!