Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
UPN | Proxy UPN |
gfb7c@Domain.com | ach3q@Domain.com |
twd2e@Domain.com | cv2qm@Domain.com |
bea4k@Domain.com | ac7xa@Domain.com |
drb7c@Domain.com | abcg6@Domain.com |
Expected result: IF(USERPRINCIPALNAME() = CONTAINS('RLS Proxy','RLS Proxy'[Proxy UPN])),
Then--> Get UPN value assigned,
Else--> USERPRINCIPALNAME())
Thanks
VCK
What is purpose of - CONTAINS('RLS Proxy','RLS Proxy'[Proxy UPN]))
Checking UPN is existing aren't in RLS proxy table. If logged in UPN is listed in RLS proxy table, then get assigned UPN.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |