Forum Discussion
Help with Row Level Security logic
Anonymous Hi Neeko - thank you for the response. A simple solution was to just add this person to the role (in the Power Bi service) and that seems to be working!
Hi Anonymous ,
According to my understanding and research of the RLS function, if you have implemented dynamic RLS through the DAX statement writing logic in RLS applied to the value of the user UPN field in the related user table, then each user in the user table is equal, unless you use the If() statement in the DAX expression to separately define the data viewing logic corresponding to the user's role, so for your needs, I think there are only two possibilities to achieve at present:
Define a new role separately for the user "[email protected]" and write specific data viewing logic
If you have the need to view the data set in full, you can consider directly sharing the "Write" permission of a data set to the user, which can ignore the logic of RLS and allow users to have the permission to view the data set in full, please refer to this document for details:
Dataset permissions - Power BI | Microsoft Learn
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Hi Neeko - thank you for the response. A simple solution was to just add this person to the role (in the Power Bi service) and that seems to be working!