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.
RLSHello,
I am facing a problem with RLS and I deeply need support,
First, we have build a dashboard where we manage Teams and employees. We have applied RLS and every Team leader have access to the data of his Team. Everything worked just fine.
After a while the structure of the Teams did change, now we have employees that belong to different Teams. So, we have a duplicate Username. I have listed below an example of my table called ''User'' where I manipulate Which Team Leader sees data of which employee:
Before
Team Leader John will see data of Victoria and Team Leader Bruce will see data of Alice:
ID | UserName | ManagerID | |
1 | John | John@Company.intern | |
2 | Victoria | Victoria@Company.intern | 1 |
3 | Bruce | Bruce@Company.intern | |
4 | Alice | Alice@Company.intern | 3 |
After
Team Leader John will see data of Victoria and Alice. Team Leader Bruce will see data of Alice:
ID | UserName | ManagerID | |
1 | John | John@Company.intern | |
2 | Victoria | Victoria@Company.intern | 1 |
3 | Bruce | Bruce@Company.intern | |
4 | Alice | Alice@Company.intern | 3 |
5 | Alice | Alice@Company.intern | 1 |
I am facing a problem in relationships between the ''User'' table above where we manipulate the level of security and the ''Teams'' table where we organize the company team structure.
Is this possible? How can I set RLS with duplicated Usernames in the User table?
I look forward to your support,
Best Regards,
Solved! Go to Solution.
You can have multiple RLS rules for each user, and these rules can even contradict each other. Permissive rules will override restrictive rules.
You can have multiple RLS rules for each user, and these rules can even contradict each other. Permissive rules will override restrictive rules.
use a different RLS rule for your managers.
Hello Ibendlin,
Could you please be more precise,
Thanks in advance for your help,
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 |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |