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 mean that when I try to filter rows through RLS, cause of this 'load more' and cause of that not all companies are shown (they are hidden under 'load more', the data is not shown.
In other tables everything is OK, but in this crucial one it's not and I don't know how to deal with this bug
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