Forum Discussion
Multiple Users for Database while setting up On Premise Gateway
In your scenario, each team uses different account to connect to the database, right? If so, when the teams have same domain as yours, you can add them as Administrators for the gateway you have configured following the guide in this article, then they can add the SQL data source within this gateway and set schedule refresh for their datasets.
However, if the teams have different domain as yours, they need to install gateway on their own machines and add the SQL data source within their gateways.
Regards,
Lydia
I dont believe this is a solution at all, this is a massive limitation of the tool and will stop us from using our Database security settings from implementing our power bi solutions for 15 different teams. In order to install the personal data gateway you need to have your machine up and running for the data refreshes to work, this is not a feasible solution since our refreshes need to happen before the beginning of the day when the business gets in. People cant have their computers up and running nonstop.
phi2134,
Do the team members have same domain as yours? If so, you can share the on-premises gateway to them by adding them as gateway administrators. And just make sure that the server that installing the on-premises gateway is on.
Regards,
Lydia