Forum Discussion
Data Refresh error: "DM_GWPipeline_Gateway_CanceledError"
I've been experiencing an intermittent data refresh issue with the Power Bi Service semantic data model with the following error code: "DM_GWPipeline_Gateway_CanceledError".
No change has occurred to the data model or underlying Azure Sql database prior to this issue starting to appear intermittently.
Things I've tried:
- checking that the data connector is set to "Organizational" level of access
- updating the data connector to see if that reset things
- updating the processing power of the back-end Azure SQL database
Any help is appreciated. It's only been happening recently but has been ticking along happily for over 6 months prior to this.
Thanks in advance.
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
46 Replies
We are also experiencing the same failed refresh error DM-GWPipeline-Gateway-CanceledError and there is another thread on the same topic: https://community.fabric.microsoft.com/t5/Service/Intermittent-DM-GWPipeline-Gateway-CanceledError/m-p/4365677. We have not changed anything except upgrade our gateway version to 3000.254.3. It is affecting different data sources, all are small in size, not close to our capacity, only a few reports refreshing at the same time.
To keep everyone updated...our Microsoft ticket has been escalated and they acknowledge that other companies are seeing the same issue.
We were told to increase our disk space, to see if that resolved the issue. We have done so twice now, and are still getting the issue. Less volume of failures, but still there.
We have increase memory on the server where our gateway is too but it didn't resolve fully. Now they are saying we should roll back to October gateway version before the problem started.
October? The issue for us didn't start until January. Which version # are they saying to roll back to?
Hi 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
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.There is a Microsoft ticket submitted that has been escalated. They acknowledged several companies are having the same issue. Once there is any update from them, I'll post here and on my post as well with any details.
We updated the gateway to the latest version and are still having the issue.
Our organization started experiencing this issue last week and we are seeing around 100 failures daily. Whenever we manually re-trigger the refreshes, they always succeed. It is only scheduled refreshes that (intermittently) have this problem.
Anyone have any solutions?
[same message as my other issue]
I have again stopped experiencing this issue but it's the result of nothing I've done my end.
Initially I had heaps of errors occurring for the automated data refreshes, but not when I manually refreshed my data model (similar to how you describe your issue). The errors stopped some time after I raised this case (under another profile). They then occurred a few times again about a fortnight ago but I've not had one happen since then.
I wish I could tell you what the issue was / is.
Is it happening with a Gateway or not?
If it is a Gateway please make sure it is running the latest version of the Gateway software?
It is via the on-premise data gateways and it is on the latest version (February 2025).
We just installed the latest gateway in the hopes that it will resolve the issue. Will keep you updated.
FYI, for us it has been both scheduled refreshes as well as some manual refreshes.
We updated to the latest version last week and saw no difference. The Microsoft engineer also told us beforehand that it was unlikely to fix the issue since the February gateway version only had minor updates. He said the March version should have more changes and might resolve the issue.
I had similar issues and updated the Gateway software.
The issue seemed unrelated though, turned out to be tcp/ip traffic rules causing the
problem. The vendor handling our internet connection had updated the traffic rules which started a variety of issues at work including the Gatway refreshes crashing repeatedly.
In the end the vendor had to roll back the updates, but also had to update firmware on the hardware as they
were one version behind. They then applied the rules in batches. Everything is fine now.
Make sure you don't have to tcp/ip issues, hardware is updated and check router configurations for your Lan to Wan connectionsI do not know exactly which one but they did have to make adjustments for the Gateway traffic to and from powerbi.
I still belive their biggest problem was that they had not updated the wan device to the latest software and firmware version
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,
MenakaHi v-menakakota
The data refreshes error appears to have been resolved now for some days so I'm guessing it was related to the known resolved issue that you refer to in your post.
Thanks
Sandy
I've been dealing with this as well. We didn't have issues for a couple days, but they came back last night.
v-menakakota Can you provide some details or documentation on the "known issue" that was resolved?
It would be helpful to know things like:
-- Nature of the issue
-- Versions affected
-- Date issue started
-- Date issue resolved
We've been seeing similar sporadic failures with random datasets , but the exact error message was slightly different. I'd like to see if the timing lines up.
We've been having this issue since a couple of days.
The error message is as follow:
{"error":{"code":"DM_GWPipeline_Gateway_CanceledError","pbi.error":{"code":"DM_GWPipeline_Gateway_CanceledError","parameters":{},"details":[],"exceptionCulprit":1}}} Table:
We plan to upgrade the on premise data gateway to the lastest version tomorrow. Hope it fixes the problem, in the mean time we can't refresh a lot of our reports. 😕
We updated the gateway and we still have this error^.
