Forum Discussion
Query editor bug: list may be incomplete
Hello, it seems like clearing cache helped to solve the problem. Thank you for your help, anyway.
OK, let me make sure I have this clear now.
1. You are in Desktop with a data model built, all of the data loaded and RLS enabled.
2. You switch to viewing your report as a specific role
3. While still viewing as this role, you open Query Editor and reload your data
4. Now you can't see anything
Do I have the steps correct for repeating this?
Opposite. I firstly open Query Editor and reload data and then apply other steps
Hello, it seems like clearing cache helped to solve the problem. Thank you for your help, anyway.
OK, so then when you reload all of the data and you are NOT using an RLS role, then all you see in the data itself if you go to the data model and sort the entire table is -1 and 4? You don't see any of your other data?
If I don't use RLS, then yes, I do see the full list of companies. However, if I use RLS, I get empty reports cause RLS is established to see companies 5-8, and they are not 'unhided' from the query list.