Problem with RLS on Power desktop and Power BI Service

[Huguo90]

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.

[GilbertQ]

Hi @Huguo90 

Could I ask how you are testing the roles?

If you are testing with your own account, that will not work because you uploaded the PBIX you are an Admin and will always see everything.

You will need to log in as one of those other users to test.

[Huguo90]

Hello @GilbertQ , 

I go to security as on dataset, I put the email adress on the role and after that I click on tested as role. But It's don't work. The distributor_user works but not the RH USER: 

Normaly, I do the to good step.

[GilbertQ]

Hi @Huguo90 

Can that user also have read permissions to the underlying dataset?

Creating “Read” permissions on reports & datasets (Allowing to view datasets from remote apps) - Fou...