Forum Discussion

Gabry's avatar
Gabry
Icon for Super User rankSuper User
2 years ago
Solved

Same gateway multiple tenants

Hi guys, I have a problem. I would like to connect the same on-premises server to two different tenants. Let me explain better: I have an on-premises SQL server that we call "Server01". I would like ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Gabry ，

 

Install separate on-premises data gateways for each tenant. This means you will have one gateway for Company A and another for Company B. Each gateway should be registered under its respective tenant. After installing the gateways, configure the SQL Server data source in each gateway. Ensure that the server and database information is correctly entered and that the authentication method matches your SQL Server setup.

If appropriate and if you have administrative access to both tenants, you can consider sharing the gateway from one tenant with the other. 

 

Invite Tenant B user as guest user

Power BI Service–> Settings wheel –> Manage gateways->Select a gateway click Manage Users and add the user for tenant B

 

For more details, please refer: Manage a SQL Server data source - Power BI | Microsoft Learn

Distribute content to external guest users with Microsoft Entra B2B - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.