Override RLS

[gsk135]

I have a table which has a region field. I created a table as access with username, region, useradmin. 

I want to filter region on main table based on the username and region from access table. Useradmin's should able to see all the regions and should not filter anything. 

I tried below roles but it did not work. 

[username] = USERPRINCIPALNAME()

if ( [username] = USERPRINCIPALNAME(), true(), [useradmin]=USERPRINCIPALNAME())

[SamWiseOwl · Accepted solution]

Hi @gsk135 

Assign something like as the filter on your security table

SWITCH(

    TRUE()

    ,USERNAME() IN VALUES(Security[User]) //if the username is in the security table

    ,Security[User] = USERNAME() //filter to that user

    ,USERNAME() = "Admin" //if the user is admin return true i.e all data

    ,TRUE()

)

To test click Modelling | View As then under Other user enter the name to test. Also tick the security role you created here mine is untitled