Forum Discussion

campelliann's avatar
campelliann
Post Patron
3 years ago
Solved

Help with Gateways

Hi there, So until now I have been working with a coleague developer, we both have our personal mode gateways. Usually for a certain report we have the gateways on my machine, and if I go on vacat...
Need Help
  • TomMartens's avatar
    TomMartens
    3 years ago

    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