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
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.
I don't think you understand the problem. It is impossible to have 100 different customers working for different companies with separate PowerBI subscriptions that is not to share anything but a hosting provider. For the hosting provider today's solution is to install 100 different Windows Servers and install gateway for each of these customers separately, because only one PowerBI account can be logged in at any one gateway.
Hope this clarifies the issue.
stianbakke, have you found a solution for that?
Anonymous unfortunately no viable solution. Saw a thread exploring using docker containers, but as there are no way to configure the gateway inside the container it looks like a dead end also. I guess you need to virtualize, which is just as bad.similar issue here. I've a dozen companies each with their own tenants, but the data is on a single server. I would have less of an issue if I could share workspaces across tenants in Power BI Service but that's another thread.
short of moving to Azure SQL I don't see a solution. Creating a dozen VM instances to install the Gateway is not viable.