Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Implementing Row Level Security Based on Column 1 and 2

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,Anonymous 
    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.




Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,Anonymous 
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.