Im trying to figure out this dynamic RLS problem that i have. I want a simple RLS User table to filter allowed content using USERPRINCIPLENAME().
Example: In the case of firstname.lastname@example.org user should be seeing data only related to the following criteria:
RLS User Table
Anyone has an idea of how to acomplish this?
Thanks in advance for any possible help.
If there's relationship exited between RLS User Table and Data table and assuming the related column is A in RLS table, B in Data table, you should specify the related column in the DAX expression such as:
[B] = MAXX(filter(RLS User Table,[Email] = USERPRINCIPALNAME()),[A])
here's also other blogs could be your reference:
Thank you for the link. Greatly apreciated. I have it somewhat working at the moment but i have an issue.
I have 3 diffrent filtering criteria Country/BU/ INL. At the moment each user needs to information for each one of the criterias for RLS to work. If its missing one of the criterias it will show no data for the person.
User table: Sweden/BU1/EPC
This is working fine.
User table: Sweden/BU1/
Instead of seeing as above, he/she will see nothing because its missing the INL information (EPC)
I have one Role with some code in each of the filtering tables
How can i modify this code to allow it to filter if one of the users is missing one of the 3 requierd criteria ?
Maybe som how :
What do you think?
Hi Pragati, Thanks for sharing the link. No, i have tried and i can not det it to work. I have seen this post before. Any more ideas on how to accomplish?
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.