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

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.