Forum Discussion

jdbusselman's avatar
jdbusselman
Frequent Visitor
8 years ago
Solved

RLS vs Filter for current user

Environment:  SQL 2016, using Tabular models, Power BI, live connection with Tabular Models   I see a lot of people asking about filtering to "Current User", this is a simple and easy thing to do w...
Need Help
DooDoo's avatar
DooDoo
New Member
7 years ago

Sokon Do you have a pbi example to share as i do not succeed in implementing your solution ?

 

Thanks

 

Stephane

miguelarce's avatar
miguelarce
Regular Visitor
7 years ago

Measure1
WhoIsWatching = USERPRINCIPALNAME() 
(that is email style usernames, or you can use USERNAME() for windows style users)

Measure 2
FilterByViewer = IF(selectedvalue(table[email])=[WhoIsWatching],1,0)

Drag Measure 2 as a filter for visual, select advanced filtering and set it to 
"Show items when value IS 1"