Forum Discussion
multiple gateways on one server
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
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?
I'm not an infrastructure specialist and without knowing how your environment is set up I'm not going to venture a guess as to a specific solution. All I'd point out is that a gateway offers access to a data source on the same network as the gateway to anyone with access (and crdentials) to the gateway. If the gateway can comunicate with the data and the user can communicate with the gateway (and thus the data) then the gateway should work for you. If the gateway cannot see the data, then it needs to be set up on the network where the data resides, but the gateway itself must also still be available to the report creator. If your data is on separate domains, unless you have a method of bridging those domains so the gateway and user can see the data, then I don't think it will work. Likewise, the number of sources on one network isn't that big an issue for the gateway as long as you don't go daft with the number (not sure I can imagine an environment where a gateway has to access more than 5-10 sources on one network).
I have the same problem needing multiple gateways
Scenario:
We are a SaaS application provider. We want clients to use Power BI to connect into the apps database we host and do data analysis from their Office 365 org's Power BI Pro account.
We want to empower our clients to make better use of cloud apps like Office 365/Power BI instead of investing in their own BI tools. With having only one data gateway installed and allocated to 1 Office 365 org, we will end up having a data gateway farm of 100+ bare bones Win2016 servers, each with a different data gateway installed. Luckily we have SPLA licenses and can do this but the admin of it all is a nightmare.
The latest release of Power BI Pro is still not yet ready for SaaS providers to compliment our offerings without fattening our back ends. Something for the road map!
This is the exact scenario that I was aiming at. Realizing that hosting and cloud solutions are becoming increasingly attractive for smaller companies, we need to be able to provide a world class reporting solution in PowerBI to these customers. They might have ERP one place, CRM somewhere else just to mention two typical systems. If the ERP hosting provider wants to provide data to their customer without uploading it somewhere, a gateway is the solution. But, in order to manage it, we need to be able to run gateway as a multi-tenant type component which can serve multiple customer with data to their respective PowerBI subscriptions.
Based on your comments I'd suggest what you have to consider is a data warehouse type solution. It's not ideal having to build somethign like that, ubt if you have multiple data sets, rather than building multiple gateways, it makes more sense to consdoidate the data for reporting pruposes and have one platform that controls access via RLS. Wouls also make standardising your reporting easier.
