Forum Discussion
multiple gateways on one server
Is it possible to configure more than one on-premise data gateway on the same Windows server?
- Anonymous9 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-msftMicrosoft 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
- jeffwinchellAdvocate 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).
- AnonymousNot applicable
kwschere No, you would need to deploy a new gateway on a different server.
- kwschereRegular 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.
- bernardfbNew 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?
- stianbakkeRegular Visitor
What if there is a hosting environment where multiple customers with multiple PowerBI subscriptions are sharing the same server?
- shill1000Helper 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.
- bernardfbNew 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?
- przemek_pbiRegular Visitor
- AnonymousNot applicable
I am also looking for this either we should have multiple installation or some how we should able to configure multiple subscription.