How can I increase the number of rows to more than 10000 in a table

[pratichhya]

I am using Grafana v9.2.0 for creating a dashboard in windows.My datasource type is elasticsearch and while creating a table panel in a dashboard it seems like I have limitation of 10000 rows which gives me wrong value at the end when I want to sum up the total cost. It was due to unable to load all data in the table and showing a total to only those that are displayed.

I want to increase my table rows to more than 10000. This is the screenshot for the section where I am changing the total rows displayed.

[usmanahmad]

Hi @pratichhya,

Thanks for opening this post.

You can check this post as it explains a possible workaround on how to increase the limit:

Show more than 500 rows in grafana table

I get more than 1000 elasticsearch records, but grafana only shows 500 rows in the table, how do I change this? Help please.

I hope this helps.