Forum Discussion
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 goes down the other one will still function.
Can someone please explain how to do this.
Thanks,
Naveen
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
3 Replies
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.
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.
RegardsHi YashikaAgrawal,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
