Implementing Row Level Security Based on Column 1 and 2

[barbdash271]

Hello!

I want to implement RLS on a single table that takes into account the email address of the person signing in, and shows all the rows that have a matching Record ID as the person signing.  I'm struggling with the second piece.

Picture 1-example data before RLS.

Picture 2- intended result. RLS would identify that Sally has signed on, identify that she's associated with two Record IDs (9379 and 8301), then show all rows that share that ID including other email addresses.

       

I tried tackling the first piece which filters by UserPrincipalName but I'm stuck on the matching ID piece.

Thanks

[Anonymous · Accepted solution]

Hi,@barbdash271 
I am glad to help you.
Your dax code seems to be miswritten, you should use =
instead of ==
like this:

[KM -Email Address V2] = USERPRINCIPALNAME()

Here is the official documentation about RLS that you can refer to:
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Make sure you set up RLS correctly in both Power BI Desktop and Power BI Service.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[barbdash271]

@amitchandak

Are you able to help?