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
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.
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?
