Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Row level security

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, somethin...
Need Help
Show and Tell
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi, Anonymous 

    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's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Anonymous 

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