Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

The users are getting error in accessing the report with RLS- "This visual contains restricted data"

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?

 

Need Help
  • dax's avatar
    dax
    7 years ago

    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.

2 Replies

  • dax's avatar
    dax
    Community Support
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.