Forum Discussion

cv2qm's avatar
cv2qm
Helper I
6 years ago

USERPRINCIPALNAME DAX for Proxy Users in RLS

Hello Community,

I am trying to implement proxy users for RLS. If proxy user has logged into power bi, he has to see the assigned user data. 'RLS Proxy ' table I am trying to do this by DAX. I tried with IF, Contains and several other functions.

I can't see expected result.

Can anyone guide me how i can achieve this by using below sample data. RLS Proxy table

UPNProxy UPN
[email protected][email protected]
[email protected][email protected]
[email protected][email protected]
[email protected][email protected]

Expected result: IF(USERPRINCIPALNAME() = CONTAINS('RLS Proxy','RLS Proxy'[Proxy UPN])),

Then--> Get UPN value assigned,

Else--> USERPRINCIPALNAME())

 

Thanks

VCK

Need Help

2 Replies

    • cv2qm's avatar
      cv2qm
      Helper I
      6 years ago

      Checking UPN is existing aren't in RLS proxy table. If logged in UPN is listed in RLS proxy table, then get assigned UPN.