Forum Discussion

YashikaAgrawal's avatar
YashikaAgrawal
Post Patron
9 months ago
Solved

Power BI multiple gateway

Hi,   Working on creating a Power BI gateway on Virtual machine. SQL server and Oracle, needs to be connected. Can we create or install two gateway, join them as a cluster so that if one of them ...
Need Help
  • sergej_og's avatar
    sergej_og
    9 months ago

    Hey YashikaAgrawal ,
    check the box in the gateway setting in Service.


    Service will take care of request distribution.

    Consider enough RAM and CPU according to your needs.
    If you don't know how much is needed monitor your VM utilization when the heavy loads are running...then you will (most likely) know.

    Regards

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
9 months ago

Hi YashikaAgrawal,

You can set up multiple On-premises Data Gateways on different virtual machines and configure them as a gateway cluster. This setup ensures high availability, supports failover, and helps avoid single points of failure by balancing the load across gateways.

Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Learn

Power BI implementation planning: Data gateways - Power BI | Microsoft Learn

Power BI high availability, failover, and disaster recovery FAQ - Microsoft Fabric | Microsoft Learn

 

Thank you.