Forum Discussion
RLS dynamic logic
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):
yes i have AD groups for managers.
if i am taking userprincipal() it showing only his own data only but i need his from which branch he want to see the particular branch all branch data.
i implemented like this is it working
[branch] = [branch] && ([Manager] = "Y" || [Regional Manager] = "N")
PBIraja again, it depends on your data model and relationships. If you have it working, please accept your post as a solution so others can benefit. If not working, please provide a screenshot of your relationships view.
Thanks!
his from which branch he want to see the particular branch total data.
i need RLS logic for the above statement.
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):
Suggest how to use two columns for single RLS role
we have branch and region also
he want see his branch all data same like his region all data.