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

[LeeDr (Lee Drengenberg)]

You could try changing a setting described here;

Reporting - CSV Export: reached the max size and contains partial data

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
It allows you to pull data directly from Elasticsearch into spreadsheets or other apps.

Regards,
Lee