Forum Discussion
Load more is gone
Hi group,
In this column, it shows "list may be incomplete", but I am not able to do the "load more" like what I could do before.
Best Regards
6 Replies
- Greg_DecklerCommunity Champion
yj1111 What is the source? SQL Server, OData, ?
- yj1111Helper I
It is Odata, and I only have 10 rows in my test source. 🙂
- Greg_DecklerCommunity Champion
yj1111 OK, I know that OData supports load more. The values that display are supposed to be from the first 1000 rows of data. The Load more then allows you to query all the data rows and retrieve the distinct values. I am wondering if because you only have 10 rows that it is perhaps essentially a bug in displaying the "List may be incomplete" message. Do all of the distinct values that you have in those 10 rows appear in the list?
- smile123New Member
I got the same issue. Is there someone knows how to fix this?
yj1111 Greg_Deckler- Greg_DecklerCommunity Champion
smile123 yj1111 I am on the June 2025 version 2.144.1378.0 64-bit (June 2025). I have a CSV file that I am using for a source. I have 4 columns. Two of them I get the Load more with and 2 others I don't. The difference seems to be whether the limit of 1000 values has been reached or not. See screenshots. I can't recall whether this has always been the case or if this is new functionality.
For yj1111 case, perhaps this is because the query is referencing another query? At least it looks like it is referencing another query. If that is the case, it would be interesting if in the original query that you can load more.