Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
ZR3036
New Member

Workgroup Access and Row Level Security

I have a report that I have successfully added RLS to in order to limit views based on user roles within the company.

 

The issue I am now up against is that in order for RLS to work, someone has to be added to the entire workgroup as a viewer, because you cannot assign viewer only in the Manage Permissions -> Direct Access of the model in Service.  I have an executive report in the workspace as well that is only for certain people, as opposed to filtering data based on org group.

 

Do I now need to enable RLS on every report within the workspace to keep restricted viewers from seeing the other executive reports?  Or is there a way to only give certain members of the workgroup access to certain reports?

1 ACCEPTED SOLUTION
blopez11
Super User
Super User

Instead of granting viewer permission on the workspace, grant read permission on the report (manager permissions->direct access).  You can use security groups to possibly make this easier.

View solution in original post

2 REPLIES 2
blopez11
Super User
Super User

Instead of granting viewer permission on the workspace, grant read permission on the report (manager permissions->direct access).  You can use security groups to possibly make this easier.

That seems to work, thank you!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.