Row level security

[vishy86]

Hi,

I am new to Row Level Security (RLS). I have a Customer Group, Customer and DM who should have access to only a specific Customer data.

I have tried to depict the above scenario, something like - 

Customer Group	Customer	DM
FF	1	A
FF	2	A
FF	3	B
FF	1	C
FF	2	C
FF	3	C
MC	1	C
MC	2	C
MC	3	C
MC	4	C
MC	5	C

DM 'A' should only have access to data related to Customer 1 & 2 of Customer Group FF.

DM 'B' should only have access to data related to Customer 3 of Customer Group FF.

DM 'C' should have access to all the Customers of both the Customer Groups FF and MC.

How can the RLS be implemented in such a scenario.

Thanks,

Vishy

[v-easonf-msft · Accepted solution]

Hi, @vishy86 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

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

[v-easonf-msft]

Hi , @vishy86 

Please follow these steps:

1.define roles and rules within Power BI Desktop

Create roles ->select the table which you want to apply a DAX rule  -> Table filter DAX expression  
DM_A :

([Customer Group] = "FF" && [Customer] = "1") ||([Customer Group] = "FF" && [Customer] = "2")

DM_B ：

([Customer Group] = "FF" && [Customer] = "3") 

DM_C ：

[Customer Group] = "FF" || [Customer Group] = "MC"

2.Manage security on your model

add a members to the role by typing in the email address

Here is  a sample

Pbix attached

Best Regards,
Community Support Team _ Eason

[amitchandak]

@vishy86 , refer if these can help

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://www.gigxp.com/row-level-security-in-powerbi-desktop/

[nandukrishnavs]

@vishy86 

Your DM column should contains loginids. 

Refer to this https://community.powerbi.com/t5/Community-Blog/Dynamic-Row-Level-Security-Dynamic-RLS/ba-p/787399

Let me know if you have any doubts.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂