# 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:** 1
**Showing post:** 2

<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

---

_[View the full topic](https://discuss.elastic.co/t/i-want-to-download-2-million-record-from-kibana-its-failing-in-reporting/253303)._