Forum Discussion
Helper IVHow to setup 2 Data Sources in a Enterprise Gateway connecting to same server or database?
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
Thanks for the reply v-piga-msft Cherry!
Actually, this solution from Hung worked for us (defined hostname alias)
https://community.powerbi.com/t5/Service/Data-Source-setup-on-Enterprise-Gateway/m-p/148597#M21516
Resident RockstarHi 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
Helper IVThanks for the reply v-piga-msft Cherry!
Actually, this solution from Hung worked for us (defined hostname alias)
https://community.powerbi.com/t5/Service/Data-Source-setup-on-Enterprise-Gateway/m-p/148597#M21516