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

Image

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  Chat with Dosu Join Discord Share on X

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  Chat with Dosu Join Discord Share on X

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.