Issue in changing the Data gateway region

[sundeepgotru]

We are trying to change the region of the On-premises data gateway which is now in default location North Europe. For our automation we wanted to change the region using the powershell command from default North Europe to our West Europe where our gata gateway is installed. Which is not happening, So looking for the Powershell/automation command to change region.

Update-DataGatewayClusterMember -GatewayClusterId ***************

this might work if we are in the right region, but our case we need to change the region and this is not allowed with below command.

Update-DataGatewayCluster -GatewayClusterId "6f41dd78-d1ef-4a7d-b392-f25eff39cdab" -RegionKey westeurope

[v-sshirivolu · Accepted solution]

Hi @sundeepgotru ,
Thanks for reaching out to Community Forum.

Thank you for checking on this. The region of an On-premises Data Gateway cannot be changed directly using PowerShell or by updating an existing gateway cluster, which is why commands such as Set- DataGatewayCluster -RegionKey do not move a gateway from one region to another. The RegionKey parameter only tells the PowerShell module which regional endpoint to connect to and it does not change the region of the existing cluster in Microsoft Power BI. However, Microsoft supports changing the gateway region during the gateway installation process when you select Migrate, restore, or takeover an existing gateway and then choose Change Region. Using this option, you can move the gateway to another region for example, North Europe to West Europe while keeping the same gateway cluster ID, so the existing datasets, dataflows, and refresh schedules will continue to work and no rebinding is required. After the migration is completed successfully, the old gateway installation can be removed or disabled. If the gateway is tied to the tenant’s default region, then changing the region may not be supported and in that case creating a new gateway cluster and rebinding workloads would be required.

Refer to these Microsoft Docs - 
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-data-region
https://learn.microsoft.com/en-us/powershell/module/datagateway/set-datagatewaycluster?view=datagate...
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install

Thank you.

[v-sshirivolu]

Hi @sundeepgotru ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[v-sshirivolu]

Hi @sundeepgotru ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.