topic Static Row Level Security in Report Server

Static Row Level Security

Eleftheria_K — Thu, 26 May 2022 13:07:19 GMT

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

Re: Static Row Level Security

Icey — Mon, 30 May 2022 05:44:11 GMT

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.

Re: Static Row Level Security

Eleftheria_K — Mon, 30 May 2022 06:44:22 GMT

Thank you!