Static Row Level Security

[Eleftheria_K]

Hello,

I have created row level security roles based on products on the Desktop. On the server, after uploading the report, setting the security configurations, I have configured some of the users to each role. But, I realised that me and my collegues are not assigned to a specific role  can not view the report. Instead they receive the message "This visual contains restricted data: to view this visual contact the dataset owner to request acess to the data behind it"

How can I configure it and the back-officers view the report filtered to the product they are responsible for (roles) and all the other viewers (managers, directors and my team) to all the data?

Thank you in advance,

Eleftheria

[Icey · Accepted solution]

Hi @Eleftheria_K ,

Based on the official document, it is needed to create a new role with all data access in Power BI Desktop and then assign the corresponding users to the role. Then they will have access to all data.

Report authors don't have access to view the report data in Power BI Report Server until they've assigned themselves roles accordingly after uploading the report.

Role assignments through group memberships are only supported when the Power BI Report Server is configured to run with NTLM or Kerberos authentication. Servers running with Custom authentication or Windows Basic need users explicitly assigned to roles.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Eleftheria_K]

Thank you!