Forum Discussion
filter datasets for column
Anonymous Watch this video on RLS, and also the first comment by the video poster, you'll get your solution.
Well i found something useful from this article https://docs.microsoft.com/en-us/power-bi/service-admin-rls.
Right now im trying to build a email adress to compare, but since [Responsible of IT] = username() is giving back the UPN in Power BI Service i have two options.
1. to build an email adress from the full name llike [email protected]
2. Or to filter the name from the email which username() gives me back
Anyone got an idea how i could solve that?
Microsoft EmployeeHi Anonymous
Here are some articles for your reference.
Using Username() in DAX with Row-Level Security
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi
Regards,
Cherie