# \[8.5.3\] Unable to download CSV from dashboard / visualizations

**URL:** <https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835>\
**Category:** Kibana\
**Tags:** elastic-stack-security, docker\
**Created:** [December 22, 2022, 12:00pm UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835 "2022-12-22T12:00:58Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![blueren](https://avatars.discourse-cdn.com/v4/letter/b/ecae2f/32.png) [@blueren](https://discuss.elastic.co/u/blueren)\
**Post date:** [December 22, 2022, 12:00pm UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/1 "2022-12-22T12:00:58Z")

</div>

None of my Kibana dashboard or viz have a "Download to CVS" option showing up in 8.5.3. What am I missing? Below is my setup:

I've installed the 8.5.3 stack of elasticsearch and kibana from [this](https://www.elastic.co/guide/en/elasticsearch/reference/8.3/docker.html#docker-file) official doc.

My kibana has the following config:

```auto
# Default Kibana configuration for docker target
server.host: "0.0.0.0"
monitoring.ui.container.elasticsearch.enabled: true

xpack.security.authc.providers:
    basic.basic1:
        order: 0
    anonymous.anonymous1:
        order: 1
        credentials:
            username: "${KIBANA_ANON_USERNAME}"
            password: "${KIBANA_ANON_PASSWORD}"

xpack.reporting.roles.enabled: false

```

I've set up a the target user as per [this](https://www.elastic.co/guide/en/kibana/8.5/secure-reporting.html#reporting-roles-user-api) doc:

User Role:

```auto
curl -s -X PUT --cacert config/certs/ca/ca.crt -u "${ELASTIC_USERNAME}:${ELASTIC_PASSWORD}" -H "Content-Type: application/json" http://elasticsearch-1:9200/_security/user/"${KIBANA_ANON_USERNAME}" -d "{ \"password\" : \"${KIBANA_ANON_PASSWORD}\", \"roles\" : [\"reporting_user_role\"] }"

```

User Profile:

```auto
curl -s -X PUT --cacert config/certs/ca/ca.crt -u "${ELASTIC_USERNAME}:${ELASTIC_PASSWORD}" -H "kbn-xsrf: reporting" -H "Content-Type: application/json" http://kibana:5601/api/security/role/anon_user_role -d '{
    "name": "custom_reporting_role",
    "metadata": {},
    "transient_metadata": {
        "enabled": true
    },
    "elasticsearch": {
        "cluster": [],
        "indices": [
            {
                "names": ["why*"],
                "privileges": ["read", "view_index_metadata", "all"],
                "allow_restricted_indices": false
            }
        ],
        "run_as": []
    },
    "kibana": [
        {
            "base": [],
            "feature": {
                "dashboard": ["minimal_read", "generate_report", "download_csv_report"],
                "discover": ["minimal_read", "generate_report"],
                "canvas": ["minimal_read", "generate_report"],
                "visualize": ["minimal_read", "generate_report"]
            },
            "spaces": ["*"]
        }
    ]
}'

```

I'm unable to view a "Download to CSV" in any of my viz / dashboards. What am I missing?

![image](https://us1.discourse-cdn.com/elastic/original/3X/4/b/4bff00ce9b24397bfa2e8945d5ec6a16a4ed69b6.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:** [December 22, 2022, 3:14pm UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/2 "2022-12-22T15:14:26Z")

</div>

Hi @blueren,

what type of visualizations are those panel made of? Are they made of Lens visualizations?  
If you open the visualization in the editor would you see the `Share` or `Download CSV` button on the top right navigation bar?

---

<div class="post-metadata">

**Author:** ![blueren](https://avatars.discourse-cdn.com/v4/letter/b/ecae2f/32.png) [@blueren](https://discuss.elastic.co/u/blueren)\
**Post date:** [December 23, 2022, 6:24am UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/3 "2022-12-23T06:24:18Z")

</div>

@Marco_Liberati ,

I've just created a couple of viz using TSVB, and a datatable. With a very basic count.  
I don't see any option anywhere to get a Download to CSV option. Attached below is a sample viz. I've currently loggend in using the 'elastic' user, which is supposed to be a superadmin of sorts right?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91d01ce9185d2810cde43ce5a6d07380b18ddf26.png)

---

<div class="post-metadata">

**Author:** ![hendry.lim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendry.lim/32/71328_2.png) [@hendry.lim](https://discuss.elastic.co/u/hendry.lim)\
**Post date:** [December 23, 2022, 6:43am UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/4 "2022-12-23T06:43:58Z")

</div>

For Agg based viz, you need to enable `Show toolbar` under `Options` tab to display the `Export` link on the data table.

---

<div class="post-metadata">

**Author:** ![blueren](https://avatars.discourse-cdn.com/v4/letter/b/ecae2f/32.png) [@blueren](https://discuss.elastic.co/u/blueren)\
**Post date:** [December 23, 2022, 7:19am UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/5 "2022-12-23T07:19:54Z")

</div>

When I open a visualization -\> inspect -\> Downlowd CSV is visible. But when I make a bunch of vizualiations as part of a dashboard and click on the gear symbol against each individual viz, I'm unable to view the download option for CSV

---

<div class="post-metadata">

**Author:** ![hendry.lim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendry.lim/32/71328_2.png) [@hendry.lim](https://discuss.elastic.co/u/hendry.lim)\
**Post date:** [December 23, 2022, 7:34am UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/6 "2022-12-23T07:34:57Z")

</div>

"Download CSV" won't be visible through the context menu/gear icon for agg based visualisation. Enable the `Show toolbar` option to be able to download CSV from aggregation based data table.

---

<div class="post-metadata">

**Author:** ![blueren](https://avatars.discourse-cdn.com/v4/letter/b/ecae2f/32.png) [@blueren](https://discuss.elastic.co/u/blueren)\
**Post date:** [December 23, 2022, 10:11am UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/7 "2022-12-23T10:11:06Z")

</div>

Thanks. Where do I find the `show toolbar` option? Is it at the viz level or the dashbaord level? A screenshot would be most helpful!

---

<div class="post-metadata">

**Author:** ![hendry.lim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendry.lim/32/71328_2.png) [@hendry.lim](https://discuss.elastic.co/u/hendry.lim)\
**Post date:** [December 23, 2022, 2:01pm UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/8 "2022-12-23T14:01:41Z")

</div>

> [@blueren](#):
>
> ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91d01ce9185d2810cde43ce5a6d07380b18ddf26.png)

Options tab on this viz.

---

<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:** [January 9, 2023, 9:14am UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/9 "2023-01-09T09:14:49Z")

</div>

The `Downloas as CSV` action should be visible in the nested context menu of the panel:

 ![Screenshot 2023-01-09 at 10.13.29](https://us1.discourse-cdn.com/elastic/original/3X/b/4/b44e91c0082b368009767a38ea0b8d18a801b6f7.jpeg)

---

<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:** [February 6, 2023, 9:15am UTC](https://discuss.elastic.co/t/8-5-3-unable-to-download-csv-from-dashboard-visualizations/321835/10 "2023-02-06T09:15:15Z")

</div>

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