Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RLS multiple combination

Hi there, I would like to implement Dynamic RLS in Power BI but not like Corporate Heirachy manager or report to The data contain multiple companis and departments and the rolle need to be based on...
Need Help
  • jtownsend21's avatar
    jtownsend21
    7 years ago

    I just remembered that I had to do something strange with my tables which required me to use the OR. For yours, you should be able to just use the following: 

    1. On the company table - Company[PrincipalName] = UserPrincipalName() 
    2. On the department table - Department[PrincipalName] = UserPrincipalName()

    If it doesn't work for you I will work up a PBIX file that I can share to demonstrate what I am thinking. 

jtownsend21's avatar
jtownsend21
Responsive Resident
7 years ago

I just remembered that I had to do something strange with my tables which required me to use the OR. For yours, you should be able to just use the following: 

  1. On the company table - Company[PrincipalName] = UserPrincipalName() 
  2. On the department table - Department[PrincipalName] = UserPrincipalName()

If it doesn't work for you I will work up a PBIX file that I can share to demonstrate what I am thinking. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

 

Could you tell what strange thing you did. I have a feeling it might work out for me as I am looking for a different solution for a different problem.

 

Thanks