topic Row Level Security in DAX Commands and Tips

Row Level Security

Anonymous — Wed, 12 Oct 2022 21:33:31 GMT

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.

Step 1. Create DIM USER Table

User {Name}

User ID {Email}

TAP {Name}

UserName	UserID	TAP
Susan White	email	TEA
Nick Varney	email	Ed Direction
Will McPherson	email	Kitamba
Jen Craver	email	Maya

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

Re: Row Level Security

v-zhangti — Thu, 13 Oct 2022 05:48:48 GMT

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.

Re: Row Level Security

Anonymous — Thu, 13 Oct 2022 14:09:40 GMT

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.