Forum Discussion
Advocate VGateway Upgrade / Installation - Rebind datasources
Hi
I have had a issue with an upgrade and had to reinstall the gateway due to a recovery key issue
I am now having reset up the datasources to point the gateway - but is there a way I can do this in python or powershell - as I am unable to this in the service as below
I want to go from PowerBiGatewayA > PowerBIGatewayB
I can see there is a some APIs/ rebind source scripts but not sure which one will update these datasources in the service.
I am not worried about doing a bulk update if needs be fo authenication just a change in the cluster
Any help appreciated.
Thanks
Karen
Hi KarenL7,
Since the original gateway cluster is still available, we recommend installing the new/reinstalled gateway and adding it as a member of the existing gateway cluster. Microsoft documents selecting Add to an existing cluster and providing the recovery key of the existing gateway when registering the additional gateway. The Add-DataGatewayClusterMember PowerShell cmdlet also provides a programmatic way to add a new gateway member to an existing cluster.
Install an on-premises data gateway | Microsoft Learn
Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Learn
Add-DataGatewayClusterMember (DataGateway) | Microsoft Learn
Thank you.
5 Replies
- tayloramy
Super User
Hi KarenL7,
While there are APIs to create connections, there is no way that I know of to reassign a connection from one gateway to another.
https://learn.microsoft.com/en-us/rest/api/fabric/core/connections/create-connection?tabs=HTTP
The recommended approach when migrating gateways is to install the new gateway as a new node in the existing cluster, and then deactivate the old node.
KarenL7Thank you tayloramy for letting me know
However, I have now found that I have some time to think on this as I have still have the original cluster being available.
Thanks for your help .
Karen
v-saisrao-msftCommunity Support
Hi KarenL7,
Since the original gateway cluster is still available, we recommend installing the new/reinstalled gateway and adding it as a member of the existing gateway cluster. Microsoft documents selecting Add to an existing cluster and providing the recovery key of the existing gateway when registering the additional gateway. The Add-DataGatewayClusterMember PowerShell cmdlet also provides a programmatic way to add a new gateway member to an existing cluster.
Install an on-premises data gateway | Microsoft Learn
Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Learn
Add-DataGatewayClusterMember (DataGateway) | Microsoft Learn
Thank you.
- v-saisrao-msft
HI KarenL7,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
- v-saisrao-msft
HI KarenL7,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
