Forum Discussion
Advocate IData Refresh error: "DM_GWPipeline_Gateway_CanceledError"
Hi sandy_ew ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Before it was a known issue but is resolved now .Please try to refresh it again and check it once.If you still face the same issue please raise a support ticket.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Regards,
Menaka
Advocate II'm still looking for the solution. Nothing has changed on the Power BI Service side ... that I know of. I'm the only person maintaining the Power BI reports so I can also be confident nothing has changed on the reports.
I've asked the relevant people to check the on-premise gateway server/s and let me know if anything has changed...... having said this, the Power BI reports are not connected to the gateway database for about 12 months and have been working fine on the Azure SQL database that whole time until this intermittent data refresh failure started.
Same problem, connection is good to the sql server , but one table always errors out.
I re-published and then it works on a manual refresh, but then the automated refresh always fails on the one query/table. This just started since last friday.
Report works fine from powerbi desktop and refreshes with no errors.
it's like something structure wise has been buffered/stored in the semantic model
and it can't fix the problem and I can't see what the problem is either
It would be really good to get a Microsoft person to let us know why this is happening - the reason why it started in the first place. This might help explain why it's all fixed for me but still happening for others.
My current guess is that it's related to the gateway version installed on the cloud servers for Azure SQL.... but this is a total guess with the error message given and the lack of any official information on why the issue occurred.
