Forum Discussion
Do I need two gateways to access data on a shared SQL Server from two domains?
I have a client I have been working with, accessing data from an on-premise SQL Server instance (SQLServer.Domain.1) using Power BI (Domain1.com) using an on-premise gateway. All good. He has a b...
AbhiSSRS
Solution Sage
Solution SageYou cannot install 2 standard gateways on a single machine and for 2 different tenants you will always need 2 different gateways signed in with the relevant tenant ids.
Now there are 2 possibilities you can explore :
Install 1 personal and 1 standard ( personal will cater to limited datasources only )
In case your datasets are import mode , you may explore to create a powershell script to change gateway configuration and sync with your dataset refreshes for respective tenants.