Forum Discussion

saranee's avatar
saranee
Helper I
8 years ago
Solved

Row level security to see organization data for different users

Hi all,

 

Request your help on this : 

We have a table containing emailids of some people outside our orgainization and also within our organization.The requirement is that when these people log on they are going to see all the detail only of their organizations(all data related to them as well as of others who belong to same organization).

 

Please can you help me with the dax expression .

 

I tried applying a filter on organization name column in manage roles in power bi desktop but this not at all working:

LOOKUPVALUE([Organization Name],Emailid,USERNAME())

 

My objective is to pick up organization name if the emailid of the person logged on is there in emailid column.

 

Thnaks,

Saranee

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    saranee,

     

    The following DAX filter expression works for me. You might also need to check the relationship.

    [Organization Name] = LOOKUPVALUE(Table1[Organization Name],Table1[Emailid],USERPRINCIPALNAME())

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    saranee,

     

    The following DAX filter expression works for me. You might also need to check the relationship.

    [Organization Name] = LOOKUPVALUE(Table1[Organization Name],Table1[Emailid],USERPRINCIPALNAME())