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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
quipmaster
Resolver I
Resolver I

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 dashboard unfiltered by RLS?

 

Case

RLS works for the vendors. But my coworkers are blocked from seeing the row-level data because they are not vendors. My dashboard uses a slicer to filter the data by vendor only.

 

quipmaster_1-1665610107549.png

 

 

Step 1. Create DIM USER Table

User {Name}

User ID {Email}

TAP {Name}

UserNameUserIDTAP
Susan WhiteemailTEA
Nick VarneyemailEd Direction
Will McPhersonemailKitamba
Jen CraveremailMaya

Step 2. Power BI Desktop

Modelling > Manage roles> Create

 

Type in Ed Direction>Dim User>Add Filter>TAP

 

DAX

[TAP] = “Ed Direction”

 

Repeat for other Kitamba and Maya.

 

Step 3. Security settings on Power BI Service.

 

Data>Row-Level Security>enter email address>add>save

 

quipmaster_0-1665610077524.png

 

 

 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @quipmaster 

 

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 AdminMember, 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.

View solution in original post

2 REPLIES 2
quipmaster
Resolver I
Resolver I

Hi @v-zhangti ,

 

That is exactly what I wanted to do. Thank you.

 

You taught me that I needed to create a workspace. Seems so simple now but I had been using the default workspace and now I know better.

 

Thank you.

v-zhangti
Community Support
Community Support

Hi, @quipmaster 

 

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 AdminMember, 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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors