# 500 Limit when using Elasticsearch Datasource

**URL:** <https://community.grafana.com/t/500-limit-when-using-elasticsearch-datasource/106400>\
**Category:** Dashboards\
**Tags:** dashboard\
**Created:** [October 26, 2023, 7:01am UTC](https://community.grafana.com/t/500-limit-when-using-elasticsearch-datasource/106400 "2023-10-26T07:01:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![blackswan](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/blackswan/32/29662_2.png) [@blackswan](https://community.grafana.com/u/blackswan)\
**Post date:** [October 26, 2023, 7:01am UTC](https://community.grafana.com/t/500-limit-when-using-elasticsearch-datasource/106400/1 "2023-10-26T07:01:13Z")

</div>

My goal is to “Group By” a certain field in Grafana. I query 1000s of documents from Elasticsearch (I know the 10k limit from ES), but in Grafana only 500 rows get displayed.  
I set the size parameter to “No limit” but limit is still at 500.

 ![image](https://us1.discourse-cdn.com/grafana/original/3X/e/0/e0f55ac7d7bcb6493b4c99734d7ed65430907efd.jpeg)

Is there a trick to overcome the 500 limit in Grafana?  
I’m using “Grafana v10.1.4 (a676a96d91)”

Thanks for any help.

---

<div class="post-metadata">

**Author:** ![josimarmartinsrj](https://avatars.discourse-cdn.com/v4/letter/j/bb73d2/32.png) [@josimarmartinsrj](https://community.grafana.com/u/josimarmartinsrj)\
**Post date:** [December 22, 2023, 3:43pm UTC](https://community.grafana.com/t/500-limit-when-using-elasticsearch-datasource/106400/2 "2023-12-22T15:43:41Z")

</div>

I was having the same problem.  
The solution is to manually add the number of lines.  
Obs:

“No limit”  
Default = 500

![ajuste_noLimite](https://us1.discourse-cdn.com/grafana/original/3X/9/f/9f4e2765980cb641a3a12826731389dea8c94bbd.jpeg)