Forum Discussion

Huguo90's avatar
Huguo90
Helper I
3 years ago

Problem with RLS on Power desktop and Power BI Service

I created a two roles on Power BI Desktop they work, when I test them on Power BI service it doesn't work, here are the codes. Can someone help me understand what happened please?

 

ROLE 1

IF(
MAXX(
FILTER('DISTRIBUTOR_USERS','DISTRIBUTOR_USERS'[Email]=USERPRINCIPALNAME()),
'DISTRIBUTOR_USERS'[DISTRIBUTOR_USERS])=1,
'DISTRIBUTOR_USERS'[Email]=USERPRINCIPALNAME(),
1=0)

 

ROLE 2

[AccountId] = LOOKUPVALUE('HR_USERS'[AccountId],
'HR_USERS'[Email],USERPRINCIPALNAME(),'HR_USERS'[AccountId],'Contact'[AccountId],'Contact'[HR_USERS]=0
)
&& 'Contact'[HR_USERS]=0

 

Thanks you.

 

3 Replies