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.
That message is not a bug, it is an indicator that you are previewing the first 100 or so rows of the data. I don't know what you mean by the list is "wrapping"?
I have 20 companies, but only the data for 1 is shown. Other companies are not filtering even after 'load more'. I do 'load more', but nothing changes.
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.