Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.