Manage Multiple data gateways separately

[BSLATTER]

Hello,

In our organization there are multiple groups that are each looking to purchase their own on-prem Gateways (hosted on their own VMs) for PowerBI and PowerApps, etc.

In reading online it looks like within an organization multiple gateways are handled by the same administrator? Is it possible to have each gateway managed separately? IE different administrators and users per gateway (and different credentials)

The reason for this is the different groups don't want their gateway(s) being tied up with data refresh/powerapps requests from other groups

[v-juanli-msft]

Hi @BSLATTER 

One administrator can have different gateways on different servers.

He can add data sources under this gateway and add others users under the gateway user list so to use the gateway to perform refresh.

However, it doesn't support different credentials for one gateway.

In addtion, it is import that the on-premise data sources should be in the same server as the gateway, thus refresh or data connection can be successful.

Best Regards
Maggie

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

[BSLATTER]

Hello @v-juanli-msft ,

Thanks for replying. I have two followup questions:

1) According to https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem it sounds like it doesn't need to exist on the same server as the data so long as it's on the same domain. IE I have a VM with the data gateway that then connects to my 3 SQL Server instances. Is this not accurate?

2) Say I am the sole administrator and we have 3 data gateways. I want Users X, Y, and Z to only be able to use Gateway #1, Users A, B, and C to use Gateway #2, and Users X and A to be able to use Gateway #3. So users X and A could use two gateways, and Y, Z, B and C could use one of the other two. Is this kind of configuration possible?