Forum Discussion
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, 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
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.
4 Replies
Anonymous
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 🙂Anonymous , 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/
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
Best Regards,
Community Support Team _ EasonHi, 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.
