Implementing RLS

[hadiali]

Hello,

I need hep in implementing RLS on my dataset. My data consists of two types of deals, Normal and Confidential. I want to Users to be able to see all Normal deals but only be able to see confidential deals they are part of.

Currently I have a UserPrincipal bridge table that connects to the Deal Member table. But what it does is is apply the security to both Normal and Confidential deals. I want to apply RLS to only confidential deals and not Normal deals.

WOuld appreciate any help in helping me solve this.

[v-angzheng-msft]

Hi, @hadiali 

Here are some references that may be useful to you:

Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security 

Share Different Visual Pages with Different Security Groups in Power BI 

Row Level Security Configuration in Power BI Desktop 

Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings 

What Do You Need to Implement Dynamic Row-Level Security in Power BI? 

Dynamic Row-Level Security in Power BI with Exclude and Include Rules 

Dynamic Row-Level Security in Power BI with NOT IN or NOT EQUAL Rule 

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-... 

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-... 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@hadiali What does your RLS rule look like and which table is it on? Seems like it should be something like:

[Deal Type] = "Normal" || USERPRINCIPALNAME() = [User]

Hard to be specific without more information. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.