The kibana reporting feature produces a partial report for size greater than 10 MB.
Do increase the size for this we need to explicitly specify the size in kibana,yml using xpack.reporting.csv.maxSizeByte: value
so do i need to have xpack purchased for this or would it work otherwise?
X-Pack is an Elastic Stack extension that provides security, alerting, monitoring, reporting, machine learning, and many other capabilities. By default, when you install Elasticsearch, X-Pack is installed.
If you want to try all of the X-Pack features, you can start a 30-day trial. At the end of the trial period, you can purchase a subscription to keep using the full functionality of the X-Pack components. For more information, see Subscriptions | Elastic Stack Products & Support | Elastic.
https://www.elastic.co/guide/en/elasticsearch/reference/current/setup-xpack.html
The maximum size of a CSV file before being truncated. This setting exists to prevent large exports from causing performance and storage issues. Defaults to 10485760 (10mB)
Cheers
Rashmi