Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Row Level Security DAX Expression not working with USERPRINCIPALNAME()

I'm trying to implement a row level security using the below code but it doesn't work as intended. However, when I replaced USERPRINCIPALNAME() with the actual email address, the RLS filter works. I...
Need Help
  • aduguid's avatar
    aduguid
    2 years ago

    Try this DAX

    [dept] = MAXX(
    FILTER(
        email_mapping, 
        CONTAINSSTRINGEXACT(TRIM(email_mapping[Permissions]), TRIM(USERPRINCIPALNAME()))
    ),
    email_mapping[Dept]
)
Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

Hi Anonymous 

 

If the Department column has a relationship with the Fact Table Department, then try this. 

CONTAINSSTRING(email_mapping[Permissions], USERPRINCIPALNAME())

Joe

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for the reply. Yes the Department column has a relationship with the Fact Table Department. The DAX Expression you have provided seems no different to mine? 

    • Joe_Barry's avatar
      Joe_Barry
      Solution Sage
      2 years ago

      It is that in that there is no need to define the Department if you have a relationship between both tables.

      I am presuming that you are using the Modeling > Manage Roles feature?