cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hiteshgaur Frequent Visitor
Frequent Visitor

How to choose new gateway in Power BI service reports/data-sets

Hi, 

I have installed two on premise gateways, one at my local machine, other on server. Power BI service recognizes both of these on "Manage Gateway" tab. I want to switch data-sets connection through to Server one rather than Local machine one. I have turned off service at my local machine, but the reports and data-sets are still connecting the same Local gateway instance. It is causing to display error in visuals on power bi reports.

 

How do I start using a brand new gateway instead of an older one with my reports?

 

Thanks very much.. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
hiteshgaur Frequent Visitor
Frequent Visitor

Re: How to choose new gateway in Power BI service reports/data-sets

Thank you @Seth_C_Bauer. I understand that I can use recovery keys to migrate. But my emphasis on using brand new gateway for existing or new reports. I ap planning to have two different gateways for devloper and production environments.

 

Any ways, I just figured it out over the weekend. It is very laborious. I have to publish my reports again, each one of them again. I wished they had a better option in the settings of Power-BI service account, some-where on Data Source Tab.

 

But for others, who are looking for the same objective, can get a clue from following screenshot:     

 

 

Selecting Multiple Instances of Gateway while publishing a report.PNG

 

 

2 REPLIES 2
Super User
Super User

Re: How to choose new gateway in Power BI service reports/data-sets

@hiteshgaur You should be able to do this pretty easily, rather than create a fresh install you can migrate or recover the laptop gateway on the server by inputting the recovery key you created when you deployed the gateway on your laptop. Power BI recognizes that key and will automatically move youre datasources over to that gateway.

The caveat here, is that the data sources need to be accessible to the server. So anything that is bound to your laptop in terms of data sources may need to be moved so that the gateway can "see" them and perform the refreshes.

Near SE WI? Join our PUG Milwaukee Brew City PUG
Highlighted
hiteshgaur Frequent Visitor
Frequent Visitor

Re: How to choose new gateway in Power BI service reports/data-sets

Thank you @Seth_C_Bauer. I understand that I can use recovery keys to migrate. But my emphasis on using brand new gateway for existing or new reports. I ap planning to have two different gateways for devloper and production environments.

 

Any ways, I just figured it out over the weekend. It is very laborious. I have to publish my reports again, each one of them again. I wished they had a better option in the settings of Power-BI service account, some-where on Data Source Tab.

 

But for others, who are looking for the same objective, can get a clue from following screenshot:     

 

 

Selecting Multiple Instances of Gateway while publishing a report.PNG