cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paulalmond91 Regular Visitor
Regular Visitor

Sharing a Gateway Across Tenants

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sharing a Gateway Across Tenants

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Sharing a Gateway Across Tenants

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
paulalmond91 Regular Visitor
Regular Visitor

Re: Sharing a Gateway Across Tenants

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.