Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Row Level Security

Hi Everyone,   I have run into a road bump with RLS. I am able to create RLS for my vendors. But I would like to have my coworkers bypass the RLS on the same dashboard. Can my coworkers view the da...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    In the service's workspace, the RLS only works for Viewers. If you want your colleague to bypass RLS and view reports directly, you can grant him a role above the Viewer level.

     

    If you publish your Power BI Desktop report to a workspace in the Power BI service, the RLS roles are applied to members who are assigned to the Viewer role in the workspace. Even if Viewers are given Build permissions to the dataset, RLS still applies. For example, if Viewers with Build permissions use Analyze in Excel, their view of the data will be protected by RLS. Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. If you want RLS to apply to people in a workspace, you can only assign them the Viewer role. Read more about roles in workspaces.

     

    Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Anonymous 

 

In the service's workspace, the RLS only works for Viewers. If you want your colleague to bypass RLS and view reports directly, you can grant him a role above the Viewer level.

 

If you publish your Power BI Desktop report to a workspace in the Power BI service, the RLS roles are applied to members who are assigned to the Viewer role in the workspace. Even if Viewers are given Build permissions to the dataset, RLS still applies. For example, if Viewers with Build permissions use Analyze in Excel, their view of the data will be protected by RLS. Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. If you want RLS to apply to people in a workspace, you can only assign them the Viewer role. Read more about roles in workspaces.

 

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.