Forum Discussion
Gateway settings not persisting through edits.
- 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:
-
Go to Workspace >> Datasets >> Settings >> Gateway connection, and re-select the correct gateway if it changed.
-
Try to make parameter or model changes in Power BI Desktop, then re-publish ,it keeps the gateway link stable.
-
In Manage Gateways, make sure the server and database names match exactly with what’s in Power BI Desktop.
-
For automation, use the Power BI REST API (BindToGatewayInGroup or UpdateDatasource) to re-bind the dataset automatically.
-
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:
-
Go to Workspace >> Datasets >> Settings >> Gateway connection, and re-select the correct gateway if it changed.
-
Try to make parameter or model changes in Power BI Desktop, then re-publish ,it keeps the gateway link stable.
-
In Manage Gateways, make sure the server and database names match exactly with what’s in Power BI Desktop.
-
For automation, use the Power BI REST API (BindToGatewayInGroup or UpdateDatasource) to re-bind the dataset automatically.
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