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.
Hi Guys,
I've created 2 roles for my model. As seen below
[CompanyId]=
CALCULATE (
MAX ( Users[CompanyId] ),
FILTER ( Users, Users[Email] = USERPRINCIPALNAME() )
)
[Email] = USERPRINCIPALNAME()
But below is the output I'm getting which is wrong. I'm getting 3 rows istead of 1.
So my imp question is, when we select 2 roles simultaneously does it work as AND condition or it works as OR condition in Power BI. As far as I can see it is working as OR condition which should not be the case ideally. If I'm giving an email ID then I should be the data for only that ID.
Desired Output with both the roles:
Can anyone please help me with this???
Regards,
Himanshu
Solved! Go to Solution.
Hi @Anonymous ,
the permissions are combined and the highest rights take effect.
Hi @Anonymous ,
As the official document said, Multiple role mappings can result in unexpected outcomes.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
Hi @Anonymous ,
the permissions are combined and the highest rights take effect.
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |