# Trying to export data reports using Kibana discover but could not be able to export large no. of data
**URL:** https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018
**Category:** Kibana
**Tags:** elastic-stack-reporting, discover
**Created:** [March 31, 2023, 7:35am UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018 "2023-03-31T07:35:35Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Mangesh\_Mathe](https://discuss.elastic.co/u/Mangesh_Mathe)
#### Post date: [March 31, 2023, 7:35am UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/1 "2023-03-31T07:35:35Z")
Hello Team,
I'm trying to download discover search data with some of my filters.
However, When I download I see that document limit in CSV is at 10,000 documents.
Any way or setting to increase document download limit?
I've tried with advanced discover option but that didn't help.
Getting below error,
Please help me resolve this so that I can download report with my whole data which have around 3 lacs documents.
Thank you!
Mangesh Mathe
---
### Author:  [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [March 31, 2023, 8:16am UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/2 "2023-03-31T08:16:53Z")
Hey, I think you can increase your csv limit with this setting on the kibana.yml file. Something like:
`xpack.reporting.csv.maxSizeBytes: 209715200`
---
### Author:  [@Mangesh\_Mathe](https://discuss.elastic.co/u/Mangesh_Mathe)
#### Post date: [March 31, 2023, 9:22am UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/3 "2023-03-31T09:22:29Z")
Thank you for your reply.
I have updated this and restarted Kibana, but this didn't help.
---
### Author:  [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [March 31, 2023, 9:25am UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/4 "2023-03-31T09:25:41Z")
Which number have you set? does it only happen only when you are exporting from discover or does it also happen when you export from a visualization for example?
---
### Author:  [@Mangesh\_Mathe](https://discuss.elastic.co/u/Mangesh_Mathe)
#### Post date: [March 31, 2023, 9:59am UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/5 "2023-03-31T09:59:10Z")
> [@Stratoula\_Kalafateli](#):
>
> xpack.reporting.csv.maxSizeBytes: 209715200
I have used this.
I have tried exporting from discover page only.
I want the raw data (each document with every fields), that's the reason I haven't tried with visualization. Because visualization will aggregate fields and count and will return result.
---
### Author:  [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [March 31, 2023, 10:07am UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/6 "2023-03-31T10:07:28Z")
Mine was just an example, try to increase this limit to the number that the error says or above
---
### Author:  [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)
#### Post date: [March 31, 2023, 12:28pm UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/7 "2023-03-31T12:28:37Z")
> [@Mangesh\_Mathe](#):
>
> I want the raw data (each document with every fields), that's the reason I haven't tried with visualization. Because visualization will aggregate fields and count and will return result.
If this is what you want, maybe exporting through kibana is not the best option because it has some limitations that you can not pass over, no matter how much you increase some settings.
For cases like this the best approach is to query elasticsearch directly with a query that has the aggregations you need.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 28, 2023, 12:29pm UTC](https://discuss.elastic.co/t/trying-to-export-data-reports-using-kibana-discover-but-could-not-be-able-to-export-large-no-of-data/329018/8 "2023-04-28T12:29:23Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.