Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

On-premises gateway and multiple customer databases on one server

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?

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.