Facing an issue while downloading csv file in Kibana. Followed below steps : Clicked on Discover Set date range of 15 days from from. It returned some ~57K records. Clicked on save. Saved the report and clicked on share. generate CSV. This CSV file has only 10K records and size is always ~10MB ev…

It's possible you are running into the maximum file size for the CSV export: https://www.elastic.co/guide/en/kibana/current/reporting-settings-kb.html#reporting-csv-settings You can configure it via a kibana.yml setting.

Thank you Joe. I made the change and works for files ~30MB but it failed to generate report for records ~108K. Threw an error "too large file"

You are probably hitting the next limit - the CSV is stored in your Elasticsearch cluster, but there is a limit on Elasticsearch side how much you can upload at once - http.max_content_length ( https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-http.html )

Thank you, will try that out. But that brings one more point, as you said the CSV is stored in ES cluster, it will have impact on storage. How can we delete this csv from cluster? is it POST /.reporting-<yyyy.mm.dd>/_delete_by_query { "query": { "match_all": {} } }

Is this delete button introduced in version after v 7.2.0 or only for enterprise edition? I can't see it in my basic kibana 7.2.

They got added recently (7.7): https://github.com/elastic/kibana/pull/60077

CSV Export in Kibana not showing all the records

Elastic Stack Kibana

flash1293 (Joe Reuter) May 20, 2020, 8:07am 6

Exactly, it will be part of the reporting index. You can also do it via the UI by going to Management > Reporting > Selecting the report and clicking the delete button.

Topic		Replies	Views
Download CSV report from kibana discover of size greater than 10 MB Kibana	2	1663	November 10, 2020
Csv file export with 1 million records(approx 1 gb size) in kibana reporting Kibana	6	15212	April 10, 2020
Export CSV limited to 500 records Kibana	5	6294	September 27, 2019
Does Kibana supports a big csv exports? Kibana	4	1407	December 24, 2020
Cannot download csv file from kibana dashboard Kibana	12	3263	July 14, 2021

CSV Export in Kibana not showing all the records

Related topics