Forum Discussion

n3ptune's avatar
n3ptune
Icon for Helper II rankHelper II
3 years ago

Connecting to SQL on Premises servers from different Private Networks

Does anyone know if its possible to connect to multiple sql server on premise from 1 power bi tenant and setup the gateway for all of them ,so the refresh can work?
Imagine you have 10 different clients with the same software and same database which is on premise.
Can fabric help on this problem?

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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. 

    • n3ptune's avatar
      n3ptune
      Icon for Helper II rankHelper II
      3 years ago

      so 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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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.