You can try in your view -> advanced setting -> query settings - to check to box “Disable SQL rewriting“.