Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper 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 ...
Data Protection
RMDNA's avatar
RMDNA
Icon for Solution Sage rankSolution 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
Icon for Helper V rankHelper 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 😞