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.
Row Level Security
Hello All,
Please provide suggestions on the following RLS question– we have been trying for a while – but not able to solve.
We have a User table and a Department table.
User table has columns - User Id, User Name, User email, and Department Id.
The Department table has columns - Department Id, Department Name, and Department Manager.
The two tables are connected on Department Id.
With RLS, I can limit department information by user –> In Manage roles - on user table – User email = userprincipalname()
Some users have ALL in the Department Id column rather than the Id of the department – which means they should be able to see information on all the departments.
How do we code this in Row Level Security i.e., Manage Roles.
Many Thanks!!
Pav
Solved! Go to Solution.
@PavBid , refer how to handle all
Power BI- Row Level Security: Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc
Refer if needed
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
Excellent!!
Thanks very much!
@PavBid , refer how to handle all
Power BI- Row Level Security: Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc
Refer if needed
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
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 |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |