Forum Discussion
Many Data Gateways on a Server
Hi all,
we have developed a Power BI solution that connects, through a data gateway, to an on premise SQL Server DB, that relates to a thir part software. Everything works good.
Now the problem is that some customers have a cloud version of the software and the dabase is hosted on azure. We have no permission to access to this database, but the sotware house give us the possibility to take a copy of that DB and restore it to an our on premise server.
So to develop the same Power BI solution to the "cloud customers" our idea is to have a windows server where we restore all the database. The problem is, how can we configure the data gateway? Every customer has it own Power BI account in their organization, but they have to connect through our data gatway.
In the data gateway settings, on the power bi service, the must not be able to see or modify the other customer connections.
So there are many DB on the same server, one for each customers, but only one data gateway.
How can we manage this?
If the request is not clear i will try to explain this better.
Thanks in advance for help.
Best regards, Francesco
2 Replies
FrancescoSCP , for Azure SQL you can change the setting in Power BI service. Means customers can change setup once you deploy there.
From on-premise to Azure SQL. This is what you can try. Create a connection with Azure SQL and in data, transformation mode go can check the code for connection code in the advance editor.
There will be a similar code Sql Server. You need to replace the code of SQL server with Auze and then test.
refer
No, i have not to connect to azure, we have not access to it. We restore the DB from azure to a local machine.
There is a local server with many database, one for each customer. How can we manage a data gateway connection for each one?
