Forum Discussion
Helper IIConnecting to SQL on Premises servers from different Private Networks
Hi n3ptune ,
Yes, it is possible to connect to multiple SQL Server on-premise instances from a single Power BI tenant and set up the gateway for all of them. You can achieve this by installing the On-premises Data Gateway on a machine that has access to all the SQL Server instances. This gateway will act as a bridge between your on-premise databases and the Power BI cloud service, allowing data refreshes to work seamlessly.
Regarding Fabric, It may not directly help with connecting multiple SQL Server instances to Power BI, but it can be used for building and managing applications that require high availability and scalability.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIso the ideal when you have a lot of clients with different private networks will be to create the cheapest VM in azure just to install the data gateway?
and usually this access is via VPN?
Hi n3ptune ,
Yes, creating a VM in Azure to install the On-premises Data Gateway can be a solution when you have multiple clients with different private networks. This VM should have access to all the SQL Server instances on the clients' networks. Typically, this access is established via a VPN connection, such as Azure ExpressRoute or a Point-to-Site VPN gateway . This setup allows you to securely connect to the on-premise databases and refresh the data in Power BI.
Refer : Installing on-premise-data-gateway on Azure Virtual machine - Microsoft Q&A
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.