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 IHi GilbertQ,
I will ask for this to be checked as I don't manage this part.
A while ago I updated the database from an on-premise SQL Server to an Azure SQL database. I was under the impression that gateways were not used for Azure SQL connections..... is this incorrect?
The error message seems to indicate that I am still using a gateway somewhere though .... but the table name it's referring to is in the Azure SQL database so it's confusing.
Thanks in advance,
Sandy
Super UserHi sandy_ew
But I would recommend doing is going back to your power BI desktop and then changing the connection string to connect your azure sql database. We upload and see if that works.
AlexisAllerbornHi, did you find a solution for this?
we're also experiencing the same situation since last Mondeay (13th Jan 2025) At first we've thought it had to do with a shared folder hosting a couple of XLS spreadsheets because all error messages were pointing in that direction but we received on thursday the same error messaged signiling out a table on an azure sql server.
We also receive the error message on Semantic models which are solely depent on XLS spreadsheets (no sql involved).
Has anything changed on the PBI Service Side?
- sandy_ew
I'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
- sandy_ew
I'm already connected to Azure SQL and have been for about 12 months now. The on-premise database that uses the gateway, that it used to be connected to 12 months ago, is not used at all in the reports.
