Forum Discussion
Chart not updating based on role
Hi,
I have a table Sales data with Columns Emp_Name, Emp_Email, Date and Amount.
I want to show the Sales amount generated by each employee on a perticular date so, I created a column chart with Amount in Y axis and Date in X axis.
I want to show only the employee data when he reads the report.
I have crated role based on Uerprincipalname(). The DAX function i used is [Emp_Email]==Userprincipalname().
I have assigned users to the role as well.
I tested the role using view as and it is showing correct data, but when I see it in the reading view. it is showing everyone's data.
I'm not sure what am I missing.
2 Replies
NaveenGandhiMemorable Member
Hello venkatvedavyas
Only thing that strikes my mind is, Did you add required user's emails in Power BI Service and tested as role?
Take a read on below article from "Manage Role on Your Model" header.
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Let me know if this helps!
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
nvprasadSolution Sage
Hi Venkatvedavyas,
If I understand you correctly, you are able to see the right data when you test in PowerBI desktop and where as PowerBI service you are seeing all data.
If the above is your problem statement, User who is part of workspace access by default can see full data. Could you please refer to the below documentation for validating your role in PowerBi service?
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution! Regards,
VN