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,
I created a measure using below DAX and I used USERPRINCUPAL function to make sure that the non-managers in the organization are not able to see the value of this measure in the report.
I published the report to the group of users and one of the user reported that he is getting below error while accessing the report on power BI service.
Can somebody please help?
Solved! Go to Solution.
Hi shivam04,
When you publish the report in powerbi service, did you set security for the role
You could try to add this user seperately in role to see whether it work or not
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi shivam04,
When you publish the report in powerbi service, did you set security for the role
You could try to add this user seperately in role to see whether it work or not
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Zoe. It worked.
The only confusion I have on my mind is that why do I have to create a new role for this specific user as there is no RLS in my model. It is just the measure which is using the login information of the user and deciding whether it shows the measure value in the report or not and I am not hiding any row but column.
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.