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.
Yes, it SHOULD load ALL the data. But when I view through role where I specified data for which companies I can see, I cannot see anything from that 'hided' list
So you are viewing it from a role that does not have access to all of the values and you are wondering why you can't see all of the values? I'm confused.
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?
Opposite. I firstly open Query Editor and reload data and then apply other steps