RLS help

[Balhemkan]

Hello Team,

I need your assistance on below issue.

I have master table which linked to fact table .we have values like below

Usershortname	Email ID
abc	abc@xyz.com
bcd	bcd@xyz.com
efg	efg@xyz.com

we are using usershortname in slicer.

My scenario is

If abc user login he need to see only abc in slicer

if bcd user login he need to see only bcd in slicer.

if any other country user login then they need to see all the users.

How can i create RLS for below issue could you please help me.

[amitchandak]

@Balhemkan , In the role, create the following condition

if([Usershortname] in {"abc","acd"}, [Email] = userprincipalname(), true()) 

[Balhemkan]

Hi Amit,

Is there any other way instead of manually entering users. 

Because we have too many users. 

[amitchandak]

@Balhemkan , [Email] = userprincipalname()

is way, but you have the condition to ignore, that is why hard coding

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

[azakir]

Hi @Balhemkan if you have active directory step up for your organization, you should be able to use that for this exercise instead of manually entering users. 

[Balhemkan]

Hi Amit, I have AD groups in organization but how it will help for RLS. Could you please explain little brief