# No data after CSV Export - Kibana

**URL:** <https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910>\
**Category:** Kibana\
**Created:** [November 23, 2021, 7:10am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910 "2021-11-23T07:10:55Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 7:10am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/1 "2021-11-23T07:10:55Z")

</div>

Hello Team,

In reference to [No data after CSV Export - Kibana](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/288486)  
I am also facing exact same issue. Could you please help me in fixing it?  
Note:- I am using kibana 7.9.3.

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 23, 2021, 9:43am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/2 "2021-11-23T09:43:24Z")

</div>

Hi @njain213

Have you changed the `xpack.reporting.csv.maxSizeBytes` value increasing it?  
It would help to share the logs that have the `reporting` tag also.

Also, can you download CSV ok from visualizations, or you have the same issue as with reporting?

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 12:41pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/3 "2021-11-23T12:41:57Z")

</div>

Hi @Marco_Liberati

I have tried increasing xpack.reporting.csv.maxSizeBytes value but it didn't helped me out. Even for 5 results I am getting blank csv report as mentioned by other user for which I have shared reference. I am getting exact same issue.

When I have selected 1 day date and added filter, I got 14 hits and after saving it, I clicked on generate CSV.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/9/09b3a22e9e1ce3857adc99e425117fb7072a2f13.png)

Below is the latest csv that I have downloaded.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/8/08afcc974d9c6b77f0d628df707a546cb27081c9.png)

Are you talking about below logs? I have used grep command with keyword reporting in kibana logs and got below

{"type":"log","@timestamp":"2021-11-23T08:50:11Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:10.889Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}  
{"type":"log","@timestamp":"2021-11-23T08:50:14Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:14.000Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}  
{"type":"log","@timestamp":"2021-11-23T08:50:17Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:17.113Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}  
{"type":"log","@timestamp":"2021-11-23T08:50:20Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:20.227Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}  
{"type":"log","@timestamp":"2021-11-23T08:50:23Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:23.340Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}  
{"type":"log","@timestamp":"2021-11-23T08:50:26Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:26.451Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}  
{"type":"log","@timestamp":"2021-11-23T08:50:29Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:29.564Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}  
{"type":"log","@timestamp":"2021-11-23T08:50:32Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-_/\_search\n{"seq\_no\_primary\_term":true,"\_source":{"excludes":["output.content"]},"query":{"bool":{"filter":{"bool":{"minimum\_should\_match":1,"should":[{"term":{"status":"pending"}},{"bool":{"must":[{"term":{"status":"processing"}},{"range":{"process\_expiration":{"lte":"2021-11-23T08:50:32.676Z"}}}]}}]}}}},"sort":[{"priority":{"order":"asc"}},{"created\_at":{"order":"asc"}}],"size":1}"}

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 1:14pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/4 "2021-11-23T13:14:45Z")

</div>

More info regarding logs. I have checked started and completion time in reporting tab.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/f/df3f99e19bc7b7b1d22488ddff4211111721ff93.png)

* * *

{"type":"log","@timestamp":"2021-11-23T12:45:27Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-2021-11-21/\_update/kwc3ccva0l3q7a5a326h2ccs?if\_seq\_no=0&if\_primary\_term=1\n{"doc":{"attempts":1,"started\_at":"2021-11-23T12:45:27.121Z","process\_expiration":"2021-11-23T12:47:27.121Z","status":"processing","kibana\_id":"357b4983-ce1c-4944-8e83-81378f8c75c9","kibana\_name":""}}"}

* * *

{"type":"log","@timestamp":"2021-11-23T12:45:28Z","tags":["debug","Elasticsearch","data","query"],"pid":870,"message":"200\nPOST /.reporting-2021-11-21/\_update/kwc3ccva0l3q7a5a326h2ccs?if\_seq\_no=1&if\_primary\_term=1\n{"doc":{"status":"completed","completed\_at":"2021-11-23T12:45:28.014Z","output":{"content":"\"@timestamp\",\"response-status\",\"proxy-url\",datacenter,\"proxy-elapsed-time-ms\"\n","content\_type":"text/csv","max\_size\_reached":false,"csv\_contains\_formulas":false,"size":78}}}"}

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 23, 2021, 1:23pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/5 "2021-11-23T13:23:40Z")

</div>

I would propose to restore the `xpack.reporting.csv.maxSizeBytes` to its original value (`10485760`) and try again to generate a CSV from a small search.  
That should help understand if it is a possible memory issue on the machine the server is running.

Also, what is the size of the downloaded CSV with only the first header row filled?

Last, can you confirm downloading a CSV from visualizations works ok?

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 1:30pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/6 "2021-11-23T13:30:24Z")

</div>

Please find inline answers to your queries.

I would propose to restore the `xpack.reporting.csv.maxSizeBytes` to its original value ( `10485760` ) and try again to generate a CSV from a small search.  
That should help understand if it is a possible memory issue on the machine the server is running.

> > > **I have tried with 10485760 value as well but no luck.**

Also, what is the size of the downloaded CSV with only the first header row filled?

> > > **File that I have downloaded is of 78 bytes.**

Last, can you confirm downloading a CSV from visualizations works ok?

> > > I am confused on this point. Below are the steps that I am performing.

1. Go to discover Tab
2. Select index and date.
3. When I got results, click on Save button and give any name.
4. Click on share tab and click on generate csv option.

![image](https://us1.discourse-cdn.com/elastic/original/3X/7/b/7b603a98cb16ebc1856dd2e447c2cf790d3701d4.png)

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 23, 2021, 1:31pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/7 "2021-11-23T13:31:36Z")

</div>

As for last point, I meant Visualization as TSVB, Lens or other aggregation based tools. Not Discover.

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 1:32pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/8 "2021-11-23T13:32:20Z")

</div>

oh ok but I am not going on this, I am performing steps that I have mentioned above so need help on this part.

Do you need any other info from my side?

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 23, 2021, 1:34pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/9 "2021-11-23T13:34:30Z")

</div>

From the menu:

```auto
Visualize Library >
Create Visualization >
Lens

```

Drag and drop a field in the main central area and once the chart is displayed click on the top right toolbar `Download CSV`.

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 1:46pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/10 "2021-11-23T13:46:08Z")

</div>

I have tried above steps but not able to find download csv option in right side that you have mentioned.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/c/8c469dcd4c3f904cceb7d4ae0714936a5d4707a2.png)

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 23, 2021, 1:53pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/11 "2021-11-23T13:53:40Z")

</div>

Oh sorry, just realized the `Download CSV` in Lens was introduced in a later version than 7.9.3 🤦‍♂️ .

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 1:54pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/12 "2021-11-23T13:54:15Z")

</div>

no Issues. Anything else you want me to try? If not please help me out in current issue that I am facing.

Also just for your info, this issue is not limited to particular index, I am getting this for all indices.

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 23, 2021, 2:51pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/13 "2021-11-23T14:51:41Z")

</div>

One more thing, is it known issue or any bug in this version?

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 23, 2021, 3:40pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/14 "2021-11-23T15:40:54Z")

</div>

I could not find any similar issue so far.  
The strange pattern here is that headers are written, but the content is not.  
Need to investigate a bit more to understand what is going on here.

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 24, 2021, 6:47am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/15 "2021-11-24T06:47:20Z")

</div>

sure thanks. I will wait for your response, meanwhile if you need any other info from my side then do let me know.

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 25, 2021, 6:31am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/16 "2021-11-25T06:31:53Z")

</div>

Hi @Marco_Liberati

Any luck in this issue?

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 25, 2021, 9:19am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/17 "2021-11-25T09:19:01Z")

</div>

I found this issue which seems to have similar effects to those you are experiencing: [[Reporting] Streaming CSV download appears to not be working · Issue #119540 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/119540)

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 25, 2021, 12:55pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/18 "2021-11-25T12:55:50Z")

</div>

[[Reporting] Streaming CSV download appears to not be working · Issue #119540 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/119540) is an open issue, what can be done to fix this? Do you recommend anything that I can try to fix this? Also issue that you are pointing is for around 100MB size but I am facing this even for small size.

Also in reported issue, browser connection will time out if the download is stalled 2 minutes or so but that is not happening in my case. Also it was mentioned in [[Reporting] Streaming CSV download appears to not be working · Issue #119540 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/119540) , it started happening in 7.15.2 version so I believe my issue is not similar to this one.

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 26, 2021, 6:42am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/19 "2021-11-26T06:42:39Z")

</div>

Also can you confirm, the issue I am facing is bug or config issue?

---

<div class="post-metadata">

**Author:** ![njain213](https://avatars.discourse-cdn.com/v4/letter/n/74df32/32.png) [@njain213](https://discuss.elastic.co/u/njain213)\
**Post date:** [November 30, 2021, 7:45am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910/20 "2021-11-30T07:45:54Z")

</div>

Any update on this?

[Next page](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910.md?page=2)