cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
_chris_
Helper II
Helper II

Problems with RLS behaviour

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

3 REPLIES 3
_chris_
Helper II
Helper II

@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

negi007
Super User
Super User

@_chris_ will it be possible for you to share sample data for these tables. will then assist you accordingly. 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors