Bug description
If you have multiple pivot tables in the table and try to export to pivoted excel one of them, no matter what you choose it exports the first table.
Source: https://github.com/apache/superset/pull/33569#issuecomment-3210235831
Screenshots/recordings
No response
Superset version
master / latest-dev
Python version
3.11
Node version
18 or greater
Browser
Firefox
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.
- [x] 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]
This is a confirmed bug with the current "Export to Pivoted Excel" feature: when multiple pivot tables are present in a dashboard, exporting to pivoted Excel always exports the first table, regardless of which one you select. This happens because the export function uses a DOM selector ('.pvtTable') that always targets the first matching table, so it doesn't distinguish between multiple pivot tables in the dashboard. The export is handled entirely on the frontend and does not use the specific chart's context or slice ID for selection, which leads to this limitation. There are no documented workarounds or fixes for this issue at the moment, and no configuration options to change this behavior. For more technical details, see the implementation in PR #33569 and the related discussion.
To reply, just mention @dosu.
How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other 
