Forum Discussion

Balhemkan's avatar
Balhemkan
Helper III
3 years ago

RLS help

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

[email protected]

bcd

[email protected]

efg

[email protected]

 

 

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.

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Balhemkan , In the role, create the following condition

     

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

    • Balhemkan's avatar
      Balhemkan
      Helper III
      3 years ago

      Hi Amit,

      Is there any other way instead of manually entering users. 

      Because we have too many users. 

       

      • azakir's avatar
        azakir
        Resolver I
        3 years ago

        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.