# No data after CSV Export - Kibana

**URL:** <https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547>\
**Category:** Kibana\
**Created:** [November 30, 2021, 10:28am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547 "2021-11-30T10:28:15Z")\
**Posts on this page:** 12\
**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 30, 2021, 10:28am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/1 "2021-11-30T10:28:15Z")

</div>

Hi Team,  
On follow up on below issue can anyone help me out?

> [@No data after CSV Export - Kibana](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/289910):
>
> 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:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\
**Post date:** [November 30, 2021, 3:06pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/2 "2021-11-30T15:06:19Z")

</div>

Hi,

I've seen Marco has already tried helping you. I have a few more questions to help us understand what's going on:

1. You say you're getting this for all indices. Did you mean - index patterns?
2. Can you try creating a non-timebased index pattern, ie. an index pattern without a date field?
3. Does the issue happen with just the default `_source` column selected?
4. Can you c/p request and response from Discover? (In the `Inspect` tab) Feel free to redact all the data you wish to keep private

---

<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:** [December 1, 2021, 11:39am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/3 "2021-12-01T11:39:56Z")

</div>

Thanks for your reply @majagrubic

Yes I mean index patterns. Yes issue happened with just default \_source column selected. One strange thing I have observed today, when I selected date as 25th Nov I got data in CSV and when I selected 18th Nov again its blank CSV. I am using hot,warm, cold architecture. Is there something I am missing here?

---

<div class="post-metadata">

**Author:** ![majagrubic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/majagrubic/32/74459_2.png) [@majagrubic](https://discuss.elastic.co/u/majagrubic)\
**Post date:** [December 1, 2021, 2:07pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/4 "2021-12-01T14:07:03Z")

</div>

Can you confirm you are seeing data in DIscover for the selected period, just not in the generated report?

---

<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:** [December 1, 2021, 2:18pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/5 "2021-12-01T14:18:17Z")

</div>

Yes I can see data in Discover but not in CSV report.

---

<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:** [December 3, 2021, 6:43am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/6 "2021-12-03T06:43:59Z")

</div>

any update on this?

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [December 8, 2021, 7:24pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/7 "2021-12-08T19:24:41Z")

</div>

Hi, there are a few known issues which you can check into and see if yours is related:

> <https://github.com/elastic/kibana/issues/100470>
>
> Hi,
> 
> We are running Kibana 7.12.0 on docker with a Nginx reverse proxy in fron…t of it.
> The version of the Elastic cluster is also 7.12.0.
> After I save the search in Discovery section and do Share, the status of the report shows as completed. However, the downloaded .csv contains only the name of the fields on the first row. The data shown in Discovery is not in the .csv.
> 
> These are the reporting settings in kibana.yml:
> 
> xpack.reporting.enabled: true
> xpack.reporting.queue.timeout: 600000
> xpack.reporting.kibanaServer.port: 443
> xpack.reporting.kibanaServer.protocol: https
> xpack.reporting.kibanaServer.hostname: 0.0.0.0
> xpack.reporting.encryptionKey: "..."
> xpack.reporting.csv.maxSizeBytes: 1048576000
> xpack.reporting.csv.scroll.size: 1048576000
> xpack.reporting.csv.scroll.duration: 10m
> 
> Can you help us identify the issues ?
> 
> Thank you

> <https://github.com/elastic/kibana/issues/69636>
>
> \*\*Kibana version:\*\*
> 7.7.1
> \*\*Elasticsearch version:\*\*
> 7.7.1
> \*\*Server OS versi…on:\*\*
> Ubuntu 18.04
> \*\*Browser version:\*\*
> Google Chrome Version 83.0.4103.61
> \*\*Browser OS version:\*\*
> macOS Catalina 10.15.3
> \*\*Original install method (e.g. download page, yum, from source, etc.):\*\*
> Docker
> \*\*Describe the bug:\*\*
> Saved search exports an empty csv if an end time in the future is selected. This comes up when we use the commonly used date ranges like - Today, This Month.
> 
> \*\*Steps to reproduce:\*\*
> 1. Create a dashboard using a saved search
> 2. Set time range as \`This Month\`, or any range with a future end date
> 3. Download the table as csv. The csv will contain only headers, no data.
> 4. Change the end date to \`now\`
> 5. Again download the table as csv. The csv will contain data this time.
> 
> \*\*Expected behavior:\*\*
> The csv should contain data even if the end date is in future.
> \*\*Screenshots (if relevant):\*\*
> Not relevant
> \*\*Errors in browser console (if relevant):\*\*
> No errors in browser.
> \*\*Provide logs and/or server output (if relevant):\*\*
> No error logs in server.
> \*\*Any additional context:\*\*
> First learned about the error \[here\](https://discuss.elastic.co/t/kibana-saved-search-exports-an-empty-csv-if-an-end-time-in-the-future-is-selected/233327)

> <https://github.com/elastic/kibana/issues/42945>
>
> \*\*Kibana version:\*\* 7.3.0
> 
> \*\*Elasticsearch version:\*\* 7.3.0
> 
> \*\*Server OS ver…sion:\*\* centos:7
> 
> \*\*Browser version:\*\* Chrome Version 76.0.3809.87 (Official Build) (64-bit)
> 
> \*\*Browser OS version:\*\* MacOS Mojave (Version 10.14.4)
> 
> \*\*Original install method (e.g. download page, yum, from source, etc.):\*\* docker.elastic.co/kibana/kibana:7.3.0
> 
> \*\*Describe the bug:\*\* Following the instructions in https://github.com/elastic/kibana/pull/34571, I enabled \`xpack.reporting.csv.enablePanelActionDownload: true\` in the config.
> The \`Download csv...\` button now appears. For saved searches on index patterns with no time column defined the csv is generated fine. However for saved searches on index patterns with a time column the csv files are generated empty (the headers are there but no records, even though I do see rows in the dashboard).
> 
> \*\*Steps to reproduce:\*\*
> 1. Set \`xpack.reporting.csv.enablePanelActionDownload: true\` in config
> 2. Create an index pattern with a time column
> 3. Create a saved search on that index pattern
> 4. Create a dashboard with that saved search
> 5. Filter the time so that the dashboard have rows
> 6. Click on "..." for the saved search panel, and then on "Download csv"
> 
> \*\*Expected behavior:\*\*
> 
> The csv should have the same rows that the dashboard has.
> 
> @joelgriffith @tsullivan

---

<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:** [December 20, 2021, 9:36am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/8 "2021-12-20T09:36:50Z")

</div>

My issue is somewhat related to [[Reporting] Saved search exports an empty csv if an end time in the future is selected. · Issue #69636 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/69636)  
but in this link it is mentioned that if we select today or this week in timerange than issue comes but in my case it is coming for old data as well(infact mostly coming when I select last 7 days or 15 days or select particular old date.)

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [December 20, 2021, 4:49pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/9 "2021-12-20T16:49:34Z")

</div>

Hi Naman - which version are you on? 7.15?

---

<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:** [December 23, 2021, 6:56am UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/10 "2021-12-23T06:56:18Z")

</div>

its 7.9.3

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [December 27, 2021, 6:27pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/11 "2021-12-27T18:27:26Z")

</div>

Perhaps the quick ranges you are selecting, last 7 days or last 15 days, still selects an end date in the future.

Here's a key to the quick ranges:

- last day: the time range goes from the beginning of today to the end of today (future date)
- last 24 hours: the time range goes from 24 hours ago to now

I advise you to upgrade to the latest version. There are plenty of (fixed) bugs in older versions that have no workaround.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 24, 2022, 6:27pm UTC](https://discuss.elastic.co/t/no-data-after-csv-export-kibana/290547/12 "2022-01-24T18:27:50Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
