Forum Discussion

marmi's avatar
marmi
Regular Visitor
9 years ago
Solved

Multiple gateway installations for customers

Hello,   we have several customers, each of them use their own Power BI. Data is located in our server room for each customer. What would you suggest as a cost-efficient way to create gateways (one...
Gateways
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    marmi

     

    Yes, one gateway for one customer. And gateway can only be installed on Windows now.

     

    Best Regards,

    Herbert

marmi's avatar
marmi
Regular Visitor
9 years ago

No, each customer has their own databases. The purpose is to have separate Power BI's as well. We don't want the customers to see each others reports, dashboards and data.

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

marmi

 

In that case, you just need to install one on-premises gateway on each database and configure the gateway for each customer account.

 

Best Regards,

Herbert

  • marmi's avatar
    marmi
    Regular Visitor
    9 years ago

    I think you mean one gateway for each customer, and data sources to the gateway for customer's databases?

     

    Windows Containers/Docker cannot be used for this at the moment because the installer and the configurator does not support silent install and the containers are nano and core servers which are not suitable for this. This leaves VMWare virtual servers or pc desktop with Windows in it as an option.

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      9 years ago

      marmi

       

      Yes, one gateway for one customer. And gateway can only be installed on Windows now.

       

      Best Regards,

      Herbert

      • marmi's avatar
        marmi
        Regular Visitor
        9 years ago

        Ok, thanks for your info

         

        Just in case somebody is interested...

         

        Windows Containers silent installation can be done by:

         

        docker run --rm <your_container_name> powershell c:\<installation_directory>\GatewayInstall.exe /Q

         

        you can find Gatewayinstaller.exe in %TEMP% if you run downloadable PowerBIGatewayInstall.exe first on some other machine

         

        This installs on-premises data gateway 

        c:\ wmic service where started=true get  name, startname

        PBIEgwService           NT SERVICE\PBIEgwService

         

        C:\>net start

        On-premises data gateway service

         

        There is no way (that I know of) how to run On-Premises Data Gateway Configurator silently after this with all the input it needs (email,Microsoft credentials,gateway name, recovery key etc.). The configurator is a Microsoft Installer:

        C:\ProgramData\Package Cache\{0E277C24-0728-4FE0-B2F1-5C7DC7E30DD0}v1.15.6170.1\EgwComponents.msi

         

        at this point I ended my study on multiplying gateways with containers. WMWare virtual server is the only solution which we can use for this.