Forum Discussion

ptmuldoon's avatar
ptmuldoon
Resolver I
1 year ago

RLS not working with UPN?

I struggling to understand why what I think is a basic RLS role is not returning the correct user.   I've create a Gen2 Flow that imports a user table that includes their email address.   I've adde...
Need Help
ptmuldoon's avatar
ptmuldoon
Resolver I
1 year ago

Maybe this is where I'm still getting a little confused.

 

I understand I can't test another user's role in the Service.   But based on what I've done, shouldn't the report be showing myself as the logged in user? 

 

Why would the report show a different User, which is the first user listed alphabetically from the Users Table, and not my own username and information?

 

I just had another user try to access the report as well, and they received an error message of:

"you don't have permission to view the content of direct lake table"

 

I also just tried to hardcode the RLS email address like such, and it still does not show me as the logged in user?

[Email] = "[email protected]"

 

My desktop report and RLS works all as expected.  I'm just trying now to replicate everything in a Lakehouse and Service, but struggling with getting the RLS to work correctly.

 

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    ptmuldoon As said RLS will not work if you are a workspace member. The filter expression used while defining the role also will not work. So the answer to "how to display my user principal name". Create a measure with below DAX and pull it inside a card visual and check. 

    My UPN = USERPRINCIPALNAME()

     

    Thanks,

    Jai