Forum Discussion
bushanbo
5 years agoFrequent Visitor
Passing LDAP as parameter to Procedure in PowerBI
I have requirement to pass user logged inn LDAP to Procedure as below. If my LDAP is nagm then that should be passed as follows. Procedure accepts nagm or 'nagm' [meaning with or without quotes] EX...
V-lianl-msft
Community Support
5 years agoThis could be achieved through dynamic RLS:
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
bushanbo
5 years agoFrequent Visitor
Thanks for the response.
We are currently using this RLS approach only and filtering data by UserPrincipleName(). It works well only if we give App access.
We have to give workspace access to Users [self-service] and if they download the PowerBI file, they can see all data.
DB wanted to handle this backend and they asked to pass user logged inn LDAP to Procedure and so like to know if we can pass UserPrincipleName() to Procedure.