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.
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.
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.
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.
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.