Setting up enterprise gateways for two servers issue

[biswedishdevil]

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?

[v-yuezhe-msft · Accepted solution]

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