Here is the bug report Super User Idrissshatila wanted me to post in this channel: MAJOR bug as reported in thread: https://community.fabric.microsoft.com/t5/Service/RLS-and-USERELATIONSHIP-probl...
well at the end it did seem that is a bug, glad you posted it here so everyone could relate to.