Bug description
I have an Apache Superset dashboard version 5.0.0 that is already embedded in my website. In the Apache Superset application itself (when I am not accessing it through the website), the option to export a table to an Excel file is available. However, on the website where the dashboard is embedded, the option to export a table to an Excel file is not available.
Screenshots/recordings
Superset version
5.0.0
Python version
I don't know
Node version
I don't know
Browser
Chrome
Additional context
No response
Checklist
- [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Comment From: dosubot[bot]
Hi @jeevallucas! I'm Dosu and I’m helping the superset team.
The 'Export to Excel' option in embedded Superset dashboards is hidden because export functionality depends on user permissions—specifically the supersetCanCSV
(or canDownloadCSV
) flag. In embedded dashboards, the user context is usually missing or reduced, so this permission is not set, and export options (including Excel) are not shown in the UI. There are no explicit code checks for embedded mode; it's the lack of valid permissions that suppresses export features for embedded or anonymous users. To enable export in embedded dashboards, you would need to ensure the embedded user/session has the necessary export permissions, but by default, these are not granted for guest or anonymous access. More details on embedding configuration and permissions are available here.
To reply, just mention @dosu.
How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other
Comment From: jeevallucas
@dosu I already have added supersetCanCSV
but the Export to Excel
option is still missing
Comment From: dosubot[bot]
The 'Export to Excel' option is only shown if the embedded user's session actually has the 'can_csv' permission (which sets supersetCanCSV
to true in the Redux store). There is no code that disables export just because the dashboard is embedded—if the permission is present, the option appears.
Please double-check that the embedded user (for example, the guest token or JWT used for embedding) has the 'can_csv' permission assigned in Superset. You can verify this by inspecting the Redux state in the embedded dashboard or by checking the /api/v1/me/roles/
API response in the embedded context. If the permission is missing, update the role or token generation to include 'can_csv'. If you are using feature flags for full export, also ensure ALLOW_FULL_CSV_EXPORT
is enabled for full Excel/CSV export options.
If you see any errors or warnings in the browser console or Superset logs when loading the embedded dashboard, those could also help pinpoint permission or token issues.
Let me know how you are assigning the permission to the embedded user/session if you need more specific troubleshooting!
To reply, just mention @dosu.
How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other
Comment From: rusackas
Looking at the code, I/we can't see any reason the item shouldn't be visible, unless supersetCanCSV
is not added to the role being used by the guest token.
Are the other options (export to CSV, etc) visible in your embedded instance? It's not in the screenshot.