Sharing a Gateway Across Tenants

[paulalmond91]

Hi,

I have a scenario where we host a SQL Server on a cloud server. Currently this has 1 on-premises gateway installed configured to Tenant A to access data in a database on the SQL Server

We want to create a new database on the SQL Server and then connect Tenant B to the gateway for them to access the data in the second database.

I am aware you cannot have multiple gateways instaled on a single server. As such - what is the recommended best practice to enable access for Tenant B?

[v-cherch-msft · Accepted solution]

Hi @paulalmond91 

It seems there's no better way to achieve that.For further,please refer to below posts.

https://community.powerbi.com/t5/Integrations-with-Files-and/Power-BI-Gateway-and-Navision-multti-te...

https://community.powerbi.com/t5/Service/multiple-gateways-on-one-server/td-p/110192

Regards,

[paulalmond91]

Thanks @v-cherch-msft  It is as I was expecting that there would not be a solution other than to segregate the databases on to different servers.

Thank you for your guidance.