Forum Discussion

TCavins's avatar
TCavins
Icon for Helper V rankHelper V
3 years ago

Row Level Security with OR

Currently have RLS working excellently! Trying to reduce the dataset size for it as every report that external people see, uses it. I want RLS to work as is for external users but want to modify the ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Do you want to keep these tables connected or are you planning to use the RLS table in lookup mode?  When you define the DAX rules for the RLS roles you can use your OR conditional as needed. Might also get away with COALESCE.