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.
Hi,
I have three tables:
1. Costcenters
2. Staff
3. RightsStaffCostcenters
I have two relations:
RightsStaffCostcenters has an m:n relation to Costcenters (one staff/manager can have the rights the see the employee data of multiple costcenters)
Costcenters has 1:n relation to Staff (1 employee is assigned to 1 costcenter but one costcenter can have multiple employees)
Let´s say, one manager has the rights to see the staff data of two costcenters.
When create a manual filter in the filter pane for the RightsStaffCostcenters table to the StaffId of the manger, my staff visual show all employees of the these two costcenters.
Now, I do not want to filter manually but using RLS. Now, when the manager logs in he sees only the employee data of one costcenter.
[StaffId]=LOOKUPVALUE(Staff[StaffId], Staff[EMail], CONCATENATE(LEFT(USERPRINCIPALNAME(), FIND("@", USERPRINCIPALNAME())), "xxx.de"))
Can someone help me with this?
Thanks and merry christmas to everyone
BR Christian
@negi007 Thanks a lot for your offer to help! That is what I was initially hoping for 🙂 However, as I want to learn things by myself, let me please first go through the article sent by and try it by myself as this seems to cover my issues @amitchandak .
I will come back to you.
Thx Christian
@_chris_, You should follow an approach like
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |