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

Setting up enterprise gateways for two servers issue

Good morning,

 

Let's imagine the following scenario:

 

Server 1 contains SQL Server Database A

Server 2 contains SQL Server Database B

 

I have a Power BI Dataset that imports data from both SQL Server Database A and SQL Server Database B, that live in different Servers.

 

Now I want to schedule data refresh, therefore I need to setup a Gateway. As far as I understood, in order to avoid VPN autentitaction, I need to install an on-premise gateway in the server where the database is located. In this case, I assume I need to install a gateway in Server 1 and another gateway in Server 2, so I can reach both servers without the need of the VPN authentication. But as you said, the dataset deployed in the Power BI service cannot use more than one gateway... so, what is the solution then?

Data analytics supporter !
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Setting up enterprise gateways for two servers issue

Hi @biswedishdevil,

Are the two servers in same network and what authentication method do you use to connect to the two databases?

If you are able to connect to the database of Server 2 from the client(for example, SSMS ) in Server 1, in other words, the gateway installed in Server 1 has access to the data source in Server 2,  you should be ok to add the two SQL Server data sources under the same gateway and use the gateway to refresh your dataset.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Setting up enterprise gateways for two servers issue

Hi @biswedishdevil,

Are the two servers in same network and what authentication method do you use to connect to the two databases?

If you are able to connect to the database of Server 2 from the client(for example, SSMS ) in Server 1, in other words, the gateway installed in Server 1 has access to the data source in Server 2,  you should be ok to add the two SQL Server data sources under the same gateway and use the gateway to refresh your dataset.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.