On Premises Data Gateway - Change Region

Hi, I installed an On Premises Data Gateway on a Azure VM. I neglected to change the region. I uninstalled the Data Gateway and tried to reinstall. Now I don't have an option to change the region during the install process. How do I fix this?

Mike Urnun 9,646 Reputation points Microsoft Employee

2020-10-27T04:44:39.847+00:00

@andrew.zwickl@kodakalaris.com AFAIK you have to reinstall the Gateway targeting the ideal region or open a support case. I'll confirm with the Gateway team and post an answer soon.

3 answers

Mike Urnun 9,646 Reputation points Microsoft Employee

2020-10-27T23:27:15.76+00:00
Hello @andrew.zwickl@kodakalaris.com - I have confirmed with the Gateway team that there's currently no other way of changing an existing selection of a region without re-installing the Gateway. You don't necessarily need to do a complete uninstall if you do the following:

Navigate to: C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway

And deleting the Gateway.bin file, and then restarting this service in task manager:

And then opening up the Gateway app from the Start menu.

Hope this helps, @andrew.zwickl@kodakalaris.com ! Please let us know if you had any further questions.
Please sign in to rate this answer.
andrew.zwickl@kodakalaris.com 6 Reputation points

2020-10-28T11:49:04.007+00:00

Hi @Mike Urnun - Thanks for your reply. I followed your instructions - delete .bin file, restart service, start Gateway app and I still have no option to set the Region on the config screen. I also tried an uninstall from Control Panel - Programs and Features and ran the install app again. Same results - no option to set the Region. Any other suggestions?

Mike Urnun 9,646 Reputation points Microsoft Employee

2020-10-29T15:23:08.413+00:00

@andrew.zwickl@kodakalaris.com If the shortcut steps above didn't work, I would go for the complete uninstall and reinstall again.

andrew.zwickl@kodakalaris.com 6 Reputation points

2020-10-29T21:13:59.513+00:00

@Mike Urnun - I did a complete uninstall from Control Panel - Programs & Features and ran the install app again. Sames results - no option to set the Region.

bmenate 1 Reputation point

2021-02-25T11:43:12.12+00:00

same, also having this problem and cannot work out how to change the region - did you work this out?

andrew.zwickl@kodakalaris.com 6 Reputation points

2021-02-25T12:48:16.627+00:00

Hi, yes, I did eventually get this resolved. I ended up creating a Azure ticket. After waiting several days for MS to respond, I tried reinstalling the Gateway and the option to change the region re-appeared. I'm unsure why the re-install finally worked or if MS did something in the background and did not inform me.

In looking back through the email chain with MS, it's possible that the server was restarted during that time period during a maintenance window which may have cause the install to work correctly. Just a thought.

Hope this helps.

bmenate 1 Reputation point

2021-02-25T14:31:32.427+00:00

thanks for responding. I actually just resolved this myself earlier by uninstalling and ensuring all traces of the gateway were gone from the system including %localappdata%, %programdata% and importantly I removed the service profile from c:\windows\serviceprofiles (which I actually think did the trick)

Robert Dupuy 6 Reputation points

2021-07-27T11:56:50.897+00:00

Same problem here. I've restarted the machine. I've deleted everything I could find in localappdata, programdata and c:\windows\serviceprofiles - although I have nothing there. And nothing has worked. It will not give me the option to create in a different region.

Robert Dupuy 6 Reputation points

2021-07-27T12:02:51.83+00:00

Navigate to C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway - done

Delete gateway.bin - there is no gateway.bin, but I've deleted everything in the folder

Open gateway app - no difference.

Robert Dupuy 6 Reputation points

2021-07-27T12:52:02.56+00:00

I finally another computer. The option to set the region does not show up with July 2021 update as far as I can tell. Brand new install - no option to set a region.

I did find a page with 6 monthly versions to download and tried March 2021 - still no option to set a region.

Maybe it has something to do with my login? After all the screen that would set the region doesn't show up until after you log in - nothing to delete, brand new installs not working.

Priya Kulkarni 0 Reputation points

2023-01-11T08:23:15.3433333+00:00

I couldn't find Gateway.bin file.
Sign in to comment
Sunny Pahlajani 1 Reputation point

2021-08-12T08:38:02.417+00:00

Please refer to this doc to verify whether the private link is enabled on the Power BI or not.

https://learn.microsoft.com/en-us/power-bi/admin/service-security-private-links#enable-private-endpoints-for-power-bi

Check if this setting is enabled on the Power BI tenant.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
shrikanthmande 1 Reputation point

2022-12-08T15:51:38.437+00:00

I was able to successfully change the region after un-installing the Gateway , Rebooting the server . During the new Installation when entering the Name of the Gateway server you would have a link to change the Regions.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment