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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 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.

Top Solution Authors
Top Kudoed Authors