I enabled audit as you suggested and found the actual problem. It was because of a missing license. I got one and problem solved.
It was confusing that I could see table properties without the license but failed when querying the data.
Log in or create a new account to continue