Forum Discussion
RLS/ OLS/ Dynamically Hiding Column Content
Hi aurelius13
How are you applying the filter? Do you plan on using a UserName() or UserPrincipalName() or something else?
Here I've made a measure that reads the persons email address and show the row if it matches the email:
The email is in the f_book next to the Author name:
Hi @SamWiseOwl! Ideally I would use RLS roles with UserName() / UserPrincipalName() so that the logged in author only ever sees their own plots but there would also be roles for people to only ever see books by a specific author, or from a certain publisher (not included in example data), etc. The measure you provided produces the desired results for the visualization but is there a way to also restrict d_Plot so authors can't see all the plots if they access that table directly?
Hi aurelius13 ,
If I understand you correctly, the measure written by SamWiseOwl already fulfills your needs. You just need to not place the Plot field in the visual object, but only the measure.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The measure SamWiseOwl suggested worked great so accepting that as the solution. I just figured out the other piece which is running RLS on the Plot table so the measure only brings in plots that "exists" for any given RLS role. Thanks both!