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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Row-Level Security with Dashboard and Workspace

Hello everyone. I am trying to implement row level security. I am using a group workspace and want most of the users to have access to only their own data on a few reports but all of the data on other reports. How does sharing a group workspace with row level security work? I know how to do it with individual reports. Do I share the reports individually with security, then the workspace/dashboard? Thank you for any help!

1 ACCEPTED SOLUTION
Tutu_in_YYC
Community Champion
Community Champion

So many options, I will provide 3. But for all of these, you will only Implement RLS only on the report that need them, and assign the users with RLS role accordingly:

 

  1. Add all users to the workspace and assigned them Viewer role (any other roles will overwrite the RLS). All the users can just access the workspace to view reports/dashboard.
  2. Dont add users to workspaces.  Create an app and share the app to the users.
  3. Dont add users to workspaces. Share reports/dashboard individually to the users.

 

If you have many users, consider using Security Group instead of sharing individually.

Hope this helps!

View solution in original post

1 REPLY 1
Tutu_in_YYC
Community Champion
Community Champion

So many options, I will provide 3. But for all of these, you will only Implement RLS only on the report that need them, and assign the users with RLS role accordingly:

 

  1. Add all users to the workspace and assigned them Viewer role (any other roles will overwrite the RLS). All the users can just access the workspace to view reports/dashboard.
  2. Dont add users to workspaces.  Create an app and share the app to the users.
  3. Dont add users to workspaces. Share reports/dashboard individually to the users.

 

If you have many users, consider using Security Group instead of sharing individually.

Hope this helps!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors