Forum Discussion

tpasley's avatar
tpasley
Frequent Visitor
10 months ago
Solved

Gateway settings not persisting through edits.

Hi All,

I've been encountering what I estimate to be a bug recently. When performing in service edits to one of our data models it seems to reset the gateway settings from cloud gateway back to V-Net gateway. This causes our overnight refresh to fail as the v-net does contain any credentials for our database connection (azure sql server). Has anyone else come across this? I did look to see if I can programatically set the gateway as part of the refresh pipeline but can't see any docs on how to do this. Any help would be massively appreciated! 

Need Help
  • rohit1991's avatar
    rohit1991
    10 months ago

    Hi tpasley 

     

    This happens quite often in Power BI Service. When you edit a dataset, it can reset the gateway mapping ,especially if both Cloud and V-Net gateways exist. That’s why the scheduled refresh fails afterward.

     

    Could you please try below steps:

    1. Go to Workspace >> Datasets >> Settings >> Gateway connection, and re-select the correct gateway if it changed.

    2. Try to make parameter or model changes in Power BI Desktop, then re-publish ,it keeps the gateway link stable.

    3. In Manage Gateways, make sure the server and database names match exactly with what’s in Power BI Desktop.

    4. For automation, use the Power BI REST API (BindToGatewayInGroup or UpdateDatasource) to re-bind the dataset automatically.

2 Replies

  • rohit1991's avatar
    rohit1991
    Icon for Super User rankSuper User
    10 months ago

    Hi tpasley 

     

    This happens quite often in Power BI Service. When you edit a dataset, it can reset the gateway mapping ,especially if both Cloud and V-Net gateways exist. That’s why the scheduled refresh fails afterward.

     

    Could you please try below steps:

    1. Go to Workspace >> Datasets >> Settings >> Gateway connection, and re-select the correct gateway if it changed.

    2. Try to make parameter or model changes in Power BI Desktop, then re-publish ,it keeps the gateway link stable.

    3. In Manage Gateways, make sure the server and database names match exactly with what’s in Power BI Desktop.

    4. For automation, use the Power BI REST API (BindToGatewayInGroup or UpdateDatasource) to re-bind the dataset automatically.

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      10 months ago

      Hi tpasley ,
      Thanks for reaching out to the Microsoft fabric community forum. 

      I would also take a moment to thank  rohit1991  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

      Additionally, you may refer to this related discussion where a similar issue was resolved:

      Solved: Re: Data Gateway not allowing me update connection... - Microsoft Fabric Community

       

      If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

      Best Regards, 
      Community Support Team