Forum Discussion

sandy_ew's avatar
sandy_ew
Icon for Advocate I rankAdvocate I
1 year ago
Solved

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 occur...
Need Help
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    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

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
1 year ago

Hi sandy_ew 

 

Could you please double check to make sure that there are no changes that have been made on the gateway server or hardware configuration also? Could it be possible to make sure you have got the latest version of the standard gateway installed?

  • sandy_ew's avatar
    sandy_ew
    Icon for Advocate I rankAdvocate I
    1 year ago

    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 

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      1 year ago

      Hi 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.

       

       

      • AlexisAllerborn's avatar
        AlexisAllerborn
        Icon for Advocate I rankAdvocate I
        1 year ago

        Hi, 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?