Forum Discussion

BBIUser's avatar
BBIUser
Helper IV
7 years ago
Solved

How to setup 2 Data Sources in a Enterprise Gateway connecting to same server or database?

Hi,   Currently, I have just one Gateway Cluster "Gateway1" and I have created 1 Data Source "Data Source1" connecting to the Server and Database. An Active Directory Service account has been creat...
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi BBIUser ,

     

    As I know, though you add the user to the User List for the data source in Data Gateway, the permission of the DB Level for the that user will not change. 

     

    So in your example, the new user will access to just 1 schema as usual.

     

    Actually, it will depends on whose credential used in the published PBIX file. If the new user get data with User 1's crendential, he will  have the same DB Level permissions (access to those same 3 schemas) as User 1. If he used his own crendential, he will only have access to 1 schema.

     

    Hope I explain it clear.

     

    If you still need help, please feel free to ask.

     

    Best Regards,

    Cherry