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.
No, of course not. Look. I have 20 companies. According to the role, I should see companies number 5, 6, 7, and 8. In the Query Editor, the preview shows me only company number 4. It results in, when I Close and Apply after Load more, and go to View as Role, I cannot see any data (cause I should see data for companies 5-8, and in Query Editor those were hided, and Load More didn't help). I hope I explained myself clearly enough now :)
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?
Hello, it seems like clearing cache helped to solve the problem. Thank you for your help, anyway.
Opposite. I firstly open Query Editor and reload data and then apply other steps
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.