Forum Discussion
Help with Gateways
Hey campelliann ,
from an architectural point of view, I do not recommend using the Power BI gateway in personal mode. I always recommend using the gateway in standard mode (fka - enterprise gateway).
Install the gateway on a server machine that is always up and running.One gateway can support more than one data source, for this reason it's not necessary to install 5 gateways for your 5 SQL Server..
From a security point of view I recommend using 5 different accounts that are used when the data source is established.
If you are using windows authenticataion you also need a dedicated account running the gateway. I recommend reading this article: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
Regards,Tom
Hey campelliann ,
from an architectural point of view, I do not recommend using the Power BI gateway in personal mode. I always recommend using the gateway in standard mode (fka - enterprise gateway).
Install the gateway on a server machine that is always up and running.
One gateway can support more than one data source, for this reason it's not necessary to install 5 gateways for your 5 SQL Server..
From a security point of view I recommend using 5 different accounts that are used when the data source is established.
If you are using windows authenticataion you also need a dedicated account running the gateway. I recommend reading this article: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
Regards,
Tom
Hmm thanks TomMartens. But lets say I have 5 different SQL databases, on 5 different remote machines, and that I also need VPN for all.
Lets say I install the gateway on a server that has the 5 vpns always on. I believe this would work. But if I am not able to have the VPN always on, I would need to install the gateway directly on the virtual/remote machines, right?