Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello dear Community,
i'm looking for a way to display datasets only if their names are listed in specific columns. Let's say John S. is the Responsible of IT, then he only can list those datasets where he's listed in the column Responsible of IT. I don't want to use roles, since i have to manage every single Person with his role.
Thank you!
Solved! Go to Solution.
@Anonymous Watch this video on RLS, and also the first comment by the video poster, you'll get your solution.
Hi @Anonymous
Based on my research, it seems there is no better way to do that. For your requirement, you may submit an idea here.
Regards,
Cherie
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 John.Wayne@outlook.com
2. Or to filter the name from the email which username() gives me back
Anyone got an idea how i could solve that?
@Anonymous Watch this video on RLS, and also the first comment by the video poster, you'll get your solution.
Well i did a workaround with building an emailadress from the Responsible name in an extra column with the help of DAX. Thank's to everyone for helping out.
Hi @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |