# Set more than 10000 number of values in data tables **URL:** \ **Category:** Kibana\ **Tags:** lens, dashboard\ **Created:** [March 12, 2025, 9:35am UTC](https://discuss.elastic.co/t/set-more-than-10000-number-of-values-in-data-tables/375766 "2025-03-12T09:35:47Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Ruben\_Mendez](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ruben_mendez/32/140473_2.png) [@Ruben\_Mendez](https://discuss.elastic.co/u/Ruben_Mendez)\ **Post date:** [March 12, 2025, 9:35am UTC](https://discuss.elastic.co/t/set-more-than-10000-number-of-values-in-data-tables/375766/1 "2025-03-12T09:35:47Z")
Hi, I'm trying to fetch more than 10000 number of values in my kibana data table visualization. ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/6/76df0e115d6215734e0dcef16dac1fa1d5874ec1.png) I get the error above, I edited index.max\_result\_window in all my elasticSearch indexes. But I get the same error I can use the same query changing the size value in json format, it works, but in Kibana not. ```json { "aggs": { "0": { "terms": { "field": "XXXXXXXX", "order": { "_count": "desc" }, "size": 100000 } } }, "size": 0, "fields": [ { "field": "Date", "format": "date_time" }, { "field": "insertion_time", "format": "date_time" } ], "script_fields": {}, "stored_fields": [ "*" ], "runtime_mappings": {}, "_source": { "excludes": [] }, "query": { "bool": { "must": [], "filter": [ { "bool": { "must_not": { "bool": { "should": [ { "match": { "Progressive": "1" } } ], "minimum_should_match": 1 } } } }, { "range": { "Date": { "format": "strict_date_optional_time", "gte": "2025-02-25T09:28:56.413Z", "lte": "2025-03-12T09:28:56.413Z" } } } ], "should": [], "must_not": [] } } } ``` What can I do to get it work? Kibana version: 8.9.0 Elastic version: 8.9.0 ---
**Author:** ![HermannSamimi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hermannsamimi/32/137155_2.png) [@HermannSamimi](https://discuss.elastic.co/u/HermannSamimi)\ **Post date:** [August 30, 2025, 7:30pm UTC](https://discuss.elastic.co/t/set-more-than-10000-number-of-values-in-data-tables/375766/2 "2025-08-30T19:30:24Z")
in short; **You can’t.** In **Kibana Lens/Data Table** , the “Top values → Number of values” has a **hard UI cap of 10,000** per terms agg. Changing index.max\_result\_window (hits pagination) doesn’t affect this, and ES might accept size: 100000 via API, but Lens won’t. **Workarounds** - Use the **Elasticsearch API** with a **composite aggregation** (paginated via after\_key) to fetch \>10k buckets. - Or materialize results with a **Transform** /rollup and visualize that. - If you truly need all distinct values in Kibana, rethink the viz—10k+ buckets is heavy and slow. instead, use a **composite aggregation** in Python and page through all buckets. ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 9, 2025, 9:38am UTC](https://discuss.elastic.co/t/set-more-than-10000-number-of-values-in-data-tables/375766/3 "2025-09-09T09:38:13Z")
Hi @Ruben_Mendez just to confirm: are you looking for more than 10000 possible values or more than 10000 rows? Because the Lens control is actually asking “how many distinct values” it should look for in your aggregation, nothing about the exact number of result rows (it can be also in the order of millions possibly) ---
**Author:** ![Tortoise](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tortoise/32/147587_2.png) [@Tortoise](https://discuss.elastic.co/u/Tortoise)\ **Post date:** [September 10, 2025, 11:15am UTC](https://discuss.elastic.co/t/set-more-than-10000-number-of-values-in-data-tables/375766/4 "2025-09-10T11:15:59Z")
Hi @Ruben_Mendez We see below enhancement open similar to the one you have raised in this post : > > > \*\*Describe the feature:\*\* > There are situations when its necessary to increase t…he max number of values of a lens table to greater than 10k events. > !\[image\](https://github.com/elastic/kibana/assets/35069463/e5d06fed-4680-45eb-8604-864324e4d8e0) > > > \*\*Describe a specific use case for the feature:\*\* > We do see the need for example when a user wants to download the results of a table and and the timeframe gets big. > > > This is a meta-issue containing links to closed issues, that have a legitimate i…mpact but cannot be prioritized for the foreseeable future. We will leave these icebox meta issues open as a place to track improvements that can be made to a feature category. > > \`\`\`\[tasklist\] > \### Tasks > \- \[\] https://github.com/elastic/kibana/issues/97278 > \- \[\] https://github.com/elastic/kibana/issues/111426 > \- \[\] https://github.com/elastic/kibana/issues/122968 > \- \[\] https://github.com/elastic/kibana/issues/125439 > \- \[\] https://github.com/elastic/kibana/issues/129218 > \- \[\] https://github.com/elastic/kibana/issues/162085 > \- \[\] https://github.com/elastic/kibana/issues/166824 > \- \[\] https://github.com/elastic/kibana/issues/171557 > \- \[\] https://github.com/elastic/kibana/issues/173744 > \`\`\` > > > > > > > > \`\`\`\[tasklist\] > \### Solvable with ESQL > \- \[\] https://github.com/elastic/kibana/issues/67206 > \- \[\] https://github.com/elastic/kibana/issues/94608 > \- \[\] https://github.com/elastic/kibana/issues/94613 > \- \[\] https://github.com/elastic/kibana/issues/101500 > \- \[\] https://github.com/elastic/kibana/issues/114951 > \- \[\] https://github.com/elastic/kibana/issues/122170 > \- \[\] https://github.com/elastic/kibana/issues/153387 > \- \[\] https://github.com/elastic/kibana/issues/165358 > \- \[\] https://github.com/elastic/kibana/issues/168228 > \`\`\` Thanks!!