Forum Discussion
PBIraja
4 years agoFrequent Visitor
RLS dynamic logic
Hi all, I need RLS dynamic logic for the below requirement if manager=Y he want to see his own total branch data manager belongs to north branch he want to see all north branch ...
- 4 years ago
PBIraja AGAIN, please provide detail on your relationships. RLS works on the ENTIRE data model.
See attached example, which assumes you do indeed have the AD group for managers, which means we can ignore the Manager = Y filter (your AD group does that already):
PBIraja
4 years agoFrequent Visitor
ok i got it your taking one table mapping to branch column.
but here one more issue
based on 2 column how can we implment
branch is one column same like another column region he want to see total his region data
- AllisonKennedy4 years agoCommunity Champion
PBIraja You're going to need to provide some sample tables/data please. How is region related to branch? Is branch a subset of region? If so then you can just use Region instead of Branch in the above example.