Forum Discussion

venujasti's avatar
venujasti
Frequent Visitor
10 years ago
Solved

multiple accounts on enterprise gateway

Hi,   I have a situation while using Enterprise gateway for powerbi, below is the scenario we are in and any suggestion are much appreciated   We have a tabular model on server X conneted to data...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi venujasti,

     

    Based on my test, if the enterprise gateway is installed on the server, and person logged on this server can only use one Power BI Service account to register the gateway currently. But we can share the data sources configured under the gateway with other users, then other user's published report can also use those data source connection without configure it again:

     

     

     

    In your scenario, if you want to remove the sever Y, you need to configure those data sources which under the [email protected] account previously under [email protected] gateway again. Then you can add the [email protected] as the administrator of this gateway like below. Then the [email protected] can add himself as those data sources users like first image. It means that two accounts can use one gateway and its data sources.

     

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

MarkSlosberg's avatar
MarkSlosberg
New Member
6 years ago

It looks like the answer is one Service Account per Enterprise Data Gateway.  I have a slightly different requirement that is affected by this reality.

 

  1. I want one Service Account with permissions set to only be able to execute SQL stored procedures to use with my Power App/Automate apps where I am using Flows to execute stored procs and not allowing my Power App to connect directly to the SQL Connector.  This seems to be a recommended best practice design pattern for performance and security.
  2. I want another Power BI Service Account with a broader set of permissions and then allow control at the Windows authentication level.

If, if fact, I can't for now have multiple service accounts for a single enterprise data gateways, can I install multiple gateways on a single SQL Server?  Probably not ideal, but could be a workaround for the time being.