Forum Discussion

Anonymous's avatar
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 vi...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

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

Anonymous's avatar
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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      7 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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 :)