Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
8 | |
3 | |
2 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
4 | |
2 |