Forum Discussion

negbc's avatar
negbc
Helper II
2 years ago
Solved

RLS not working

I setup RLS in desktop and assigned a user in BI Service in the security settings. I did this for two different reports, defined by the warehouse they work at, one reports works fine and the user has...
Need Help
  • JohnnySaade's avatar
    JohnnySaade
    2 years ago

    You are correct, users' workspace access isn't a requirement to manage their RLS as long as they have access to the report.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi negbc ,

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, users with access to a workspace have access to datasets in that workspace. RLS only restricts data access for users with Viewer permissions. It doesn't apply to Admins, Members, or Contributors.

When you set the RLS for user and share the related report with user, the RLS policy will working.

If want to add many user to the RLS, you could create group and add user to group, then add group to the RLS

You can use the following groups to set up row level security.

Note, however, that Microsoft 365 groups aren't supported and can't be added to any roles.

 

For more details, you can read related document: Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.