Forum Discussion

Pricey79's avatar
Pricey79
Helper V
3 years ago

Dropdown with restricted access?

Hi everyone, I was hoping someone could help

 

I have a dropdown slicer thats filled with names who all have a unique ID.

Is there a way where the person who is logged on the computer showing the dashboard(logged on with their unique ID) is only able to see their own name in the dropdown?

 

Thank you

Data Protection

2 Replies

  • RMDNA's avatar
    RMDNA
    Solution Sage
    3 years ago

    Hi Pricey79 - the function USERPRINCIPALNAME( ) returns the alias of the user who is viewing the report. You could incorporate that into a row-level security (RLS) setup to limit what a given user can see.  

    • Pricey79's avatar
      Pricey79
      Helper V
      3 years ago

      RMDNA thank you for your response. I should have mentioned that the queries conceredn are direct query, and they dont show up in the RLS editor 😞