we have several customers, each of them use their own Power BI. Data is located in our server room for each customer. What would you suggest as a cost-efficient way to create gateways (one per each customer).
- VMWare virtual server with gateway service per customer? (not the best way for us...)
- Windows Containers?
- Docker for Windows...?
Solved! Go to Solution.
No, each customer has their own databases. The purpose is to have separate Power BI's as well. We don't want the customers to see each others reports, dashboards and data.
I think you mean one gateway for each customer, and data sources to the gateway for customer's databases?
Windows Containers/Docker cannot be used for this at the moment because the installer and the configurator does not support silent install and the containers are nano and core servers which are not suitable for this. This leaves VMWare virtual servers or pc desktop with Windows in it as an option.
Ok, thanks for your info
Just in case somebody is interested...
Windows Containers silent installation can be done by:
docker run --rm <your_container_name> powershell c:\<installation_directory>\GatewayInstall.exe /Q
you can find Gatewayinstaller.exe in %TEMP% if you run downloadable PowerBIGatewayInstall.exe first on some other machine
This installs on-premises data gateway
c:\ wmic service where started=true get name, startname
PBIEgwService NT SERVICE\PBIEgwService
On-premises data gateway service
There is no way (that I know of) how to run On-Premises Data Gateway Configurator silently after this with all the input it needs (email,Microsoft credentials,gateway name, recovery key etc.). The configurator is a Microsoft Installer:
at this point I ended my study on multiplying gateways with containers. WMWare virtual server is the only solution which we can use for this.
I have the same issue and was wondering whether you have a solution already. I use one server for several customers; all with their own SQL server database and their own Power BI accounts and reports. These need to split and may never mixed.
As an alternative I would use one server per customer which would create multiple server that would hardly be used most of the time but only needs a lot a performance during ETL time. This is not a cost efficient solution.
Is VMWare still the only way to go? and how I have to set it up?
Do i need to know more about hte Windows Containers (e.g. is it usefull in this respect of the problem at hand)?
Hope you can help me.