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 database X1 for department1 over which our reports are running. The reports are using Directquery to get data from the tabular model. There is an Enterprise gateway setup(on server X) using account [email protected] connecting the tabular model to reports on powerbi.com 

 

We have another server Y where another set of reports for department2 are developed over the same database X1. There is an Enterprise gateway setup(on server Y) using account [email protected] connecting the database to our reports on powerbi.com  

 

Now we are trying to get rid of server Y and move everything to server X so its easy to maintain all powerbi related stuff on one server. We want to maintain both the accounts on powebi.com and connet them through single gateway.

 

I tried setting up the gateway by logging using [email protected] on server X enterprise gateway but doing so is disabing [email protected] and vice verse.

 

can we use multiple accounts on Enterprise gateway?

 

Regards,

Venu Jasti

  • 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

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    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

    • Furanity's avatar
      Furanity
      Icon for Helper I rankHelper I
      9 years ago

      Hi Qiuyun Yu,

       

      I have more or less the same question, however, in my scenario Account1 and Account2 do not reside in the same organisation, since they are held by mutiple customers. So: account1 is for customer x ([email protected]) and account2 is for customer y ([email protected]). How would that work?

       

       

      Thanks!

      • albertoderossi's avatar
        albertoderossi
        Frequent Visitor
        7 years ago

        Hi, I have the same problem. Did you solve it?

         

        Regards

         

        Alberto

  • 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.