Forum Discussion

kwschere's avatar
kwschere
Regular Visitor
9 years ago
Solved

multiple gateways on one server

Is it possible to configure more than one on-premise data gateway on the same Windows server?

  • Anonymous's avatar
    Anonymous
    9 years ago

    kwschere No, you would need to deploy a new gateway on a different server.

  • Hi kwschere,

     

    As the on-premise gateway runs as a windows service called "PBIEgwService" on the server where it is installed, I don't think it is possible  to configure more than one on-premise data gateway on the same Windows server in this scenario.:smileyhappy:

     

    Regards

20 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    Hi kwschere,

     

    As the on-premise gateway runs as a windows service called "PBIEgwService" on the server where it is installed, I don't think it is possible  to configure more than one on-premise data gateway on the same Windows server in this scenario.:smileyhappy:

     

    Regards

    • jeffwinchell's avatar
      jeffwinchell
      Advocate I

      We have this need too because we have two email domains (our old company name and our new one and we are still in the transitioning phase where we need to use both domains).

  • Anonymous's avatar
    Anonymous
    Not applicable

    kwschere No, you would need to deploy a new gateway on a different server.

  • Baskar's avatar
    Baskar
    Resident Rockstar

    kwschere  No we can't do .

     

    My question is y u r trying to install multiple gateway in single mechine ? 

     

    One gateway is enough to connect all the source know ?

    • kwschere's avatar
      kwschere
      Regular Visitor

      This is purely for administrative reasons.  At the present time, we are purely in a discovery mode for how to use Power BI and the On-Premise Data Gateway.  From what I've been able to determine, the only person that is able to create/modify/delete data sources on the gateway is one who has been given administrator priveleges on the gateway.  We are hoping to decentralize the administration of the data sources - with business units managing their own data sources.  Thus we don't want people from different departments having the ability to touch another department's data sources.  The only way I can see to provide this setup is to create multiple gateways.  I was hoping to be able to do this without creating a glut of gateway servers. 

      • bernardfb's avatar
        bernardfb
        New Member

        Good afternoon shill1000

         

        Today I have an environment where I host a cloud ERP, where I have something very similar to scenario 1.

        I have a server that needs to share several gateways, where each gateway will be from a different client.

        Clients do not have access to this server, every configuration is performed by my team.

        But we need to create 5 or gateway services on the same server. Each service will log in with a separate domain account and connect to a different database.

        We have all policies for this to work accurately.

         

        The big problem is that we can not create more than one gateway service on the same server.

         

        Do you have any idea how to solve this?

  • stianbakke's avatar
    stianbakke
    Regular Visitor

    What if there is a hosting environment where multiple customers with multiple PowerBI subscriptions are sharing the same server?

    • shill1000's avatar
      shill1000
      Helper IV

      I'm not sure that scenario makes sense. There can only be 2 situations that apply as you've tried to show:

       

      1) A truly shared environment with one server servicing all customers from one environment. By definition (security model aside) you have one server servicing multiple customers who are all able to see all data. In that scenario you only have one server so only need one gateway. Even if you have multiple databases on that one server, one gateway can interrogate all of them.

       

      2) A single environment hosting multiple VM's. Each customer uses the same core 'tin' but each has their own virtual server on that box. In that case, each customer has their own server so each server would have a gateway, regardless of how many data sources were on that server. Having a gateway in each VM is not an issue because each runs its own services.

       

      The only scenario that complicates option 2 is if there is a need to have a gateway pulling data from each VM. Then the host server itself would probably have to have a gateway installed, and that is pointed to each VM as a distinct data source. Getting that to work depends on how you firewall each VM, not how many VM's you have on the box.

       

      I find it hard to believe that scenario exists unless each customer is going to the hosting service and asking them to provide their reporting. I can’t see multiple distinct customers being happy about a hosting organisation having full access to all their combined data, but it’s feasible. Most hosts only provide environment and support without any free access to customer data, not least because of potential conflicts between customers.

      • bernardfb's avatar
        bernardfb
        New Member

        Good afternoon shill1000

         

        Today I have an environment where I host a cloud ERP, where I have something very similar to scenario 1.

         

        I have one server that needs to share several gateways, where each gateway will be from a different client.

        Clients do not have access to this server, every configuration is performed by my team.

         

        But we need to create 5 or gateway services on the same server. Each service will log in with a separate domain account and connect to a different database. We have all policies for this to work accurately.

         

        The big problem is that we can not create more than one gateway service on the same server.

         

        Do you have any idea how to solve this?

  • Anonymous's avatar
    Anonymous
    Not applicable

    I am also looking for this either we should have multiple installation or some how we should able to configure multiple subscription.