On-premises gateway and multiple customer databases on one server

[Anonymous]

Hi,

I have a Windows server which contains multiple databases for different customers. This server has On-premises gateway but I can only connect it to one organization at a time. So basically I need to access to this server from multiple different organizations in order to get data to my Power BI reports.

Is it possible to share on-premises gateway to multiple organizations? If it's not possible, how would you solve this problem? Do I really need dedicated server to every customer so I can install one On-premises gateway per customer?

[v-piga-msft]

Hi @Anonymous ,

---

Is it possible to share on-premises gateway to multiple organizations? If it's not possible, how would you solve this problem? Do I really need dedicated server to every customer so I can install one On-premises gateway per customer?

---

I'm afraid that we can't share a gateway, but we can add administrators to the gateway, and you can add users to the gateway's data sources. Please refer to this document.

Best  Regards,

Cherry

[Anonymous]

Unfortunately that is not an option because administrators/users have to be from same tenant. If I set gateway up with credentials from company A I can only add users from company A tenant but not from company B or C tenants.