# I want to Download 2 Million Record from Kibana , Its failing in Reporting

**URL:** https://discuss.elastic.co/t/i-want-to-download-2-million-record-from-kibana-its-failing-in-reporting/253303
**Category:** Kibana
**Tags:** elastic-stack-reporting
**Created:** [October 26, 2020, 12:15pm UTC](https://discuss.elastic.co/t/i-want-to-download-2-million-record-from-kibana-its-failing-in-reporting/253303 "2020-10-26T12:15:39Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Rohit\_Kumbhar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rohit_kumbhar/32/67682_2.png) [@Rohit\_Kumbhar](https://discuss.elastic.co/u/Rohit_Kumbhar)
#### Post date: [October 26, 2020, 12:15pm UTC](https://discuss.elastic.co/t/i-want-to-download-2-million-record-from-kibana-its-failing-in-reporting/253303/1 "2020-10-26T12:15:39Z")

</div>

Hello,

Can Someone Help me solving my issue with Reports in Kibana  
I want to download 2 Million data logs from Kibana but it is Failing to download that report.  
By trial and error Somehow I can download Only 95Mb Size Report File.  
If i go Above that Its failing.

Please Help

Thanks

---

<div class="post-metadata">

### Author: ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [October 29, 2020, 8:26pm UTC](https://discuss.elastic.co/t/i-want-to-download-2-million-record-from-kibana-its-failing-in-reporting/253303/2 "2020-10-29T20:26:04Z")

</div>

You could try changing a setting described here;

> [@Reporting - CSV Export: reached the max size and contains partial data](https://discuss.elastic.co/t/reporting-csv-export-reached-the-max-size-and-contains-partial-data/116626):
>
> Hi, I get following error when exporting my data: Your report for the "mySearch" search is ready;however, it reached the max size and contains partial data. Pick it up from Management \> Kibana \> Reporting How can I increase the max number of exported bytes / events / whatever? Thanks, Andreas

Or depending on what you're going to do with the data, you might want to try the ODBC driver [SQL ODBC | Elasticsearch Guide [8.11] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-odbc.html)  
It allows you to pull data directly from Elasticsearch into spreadsheets or other apps.

Regards,  
Lee

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 26, 2020, 8:26pm UTC](https://discuss.elastic.co/t/i-want-to-download-2-million-record-from-kibana-its-failing-in-reporting/253303/3 "2020-11-26T20:26:15Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.