Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |