Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Query editor bug: list may be incomplete

Hello,

I have a bug in Query editor. It say, 'the list may be incomplete' - I click 'load more' - Apply and Close. But when checking, the list is wrapping again. It affects filtering tables in visuals, especially when I test it through Roles. I hope there is a solution.

Kind regards,

Taisiya

Anonymous
7 years ago
Hello, it seems like clearing cache helped to solve the problem. Thank you for your help, anyway.

13 Replies

Greg_Deckler
Community Champion
7 years ago
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"?
- Anonymous
  Not applicable
  7 years ago
  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
- Anonymous
  Not applicable
  7 years ago
  
  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.
  - Greg_Deckler
    Community Champion
    7 years ago
    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?
Whitmor
New Member
4 years ago
Hey there!

Were you able to figure it out? I am coming across same error.

Please advise a solution that worked for you.