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's tackle why this is an issue as in what you are trying to do. You are seeing this in Power Query, correct? But, when you load the report for real, Close and Apply, it is going to load ALL of the data, not just the preview stuff. So, you can then use that in your RLS definitions. Right?
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?