dosubot[bot] commented on issue #36944: URL: https://github.com/apache/superset/issues/36944#issuecomment-3717714105
<!-- Greeting --> Hi @shafad1! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> This is a known bug in the latest Superset (v6/master): the "Export to Pivoted Excel" feature often does not work as expected. If you have multiple pivot tables on a dashboard, exporting to Excel always exports the first table, regardless of which one you select. This happens because the export function targets the first matching table in the DOM, not the one you clicked on. There are currently no workarounds or configuration options to change this behavior, and it is confirmed to affect the latest master/dev version [details](https://github.com/apache/superset/issues/34792). If your issue is different (for example, no file is generated at all, or the file is corrupt), please check your browser console for JavaScript errors or Superset logs for Python stack traces, as there could be an additional problem. If you can share any error messages or logs, that would help narrow it down. The CSV export works because it uses a different code path and does not try to preserve the pivot structure. The Excel export is intended to keep the multi-level column structure, but this bug prevents it from working reliably in dashboards with multiple pivot tables [feature background](https://github.com/apache/superset/pull/33569). Let me know if you see a different failure mode or have error details—I'm happy to help interpret them. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/280d88f7-3750-4b66-afff-283770992c02?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/280d88f7-3750-4b66-afff-283770992c02?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/280d88f7-3750-4b66-afff-283770992c02?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/280d88f7-3750-4b66-afff-283770992c02?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/280d88f7-3750-4b66-afff-283770992c02?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/280d88f7-3750-4b66-afff-283770992c02?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/280d88f7-3750-4b66-afff-283770992c02?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=This%20is%20a%20known%20bug%20in%20the%20latest%20Superset%20%28v6/master%29%3A%20the%20%22Export%20to%20Pivoted%20Excel%22%20feature%20often%20does%20not%20work%20as%20expected.%20If%20you%20have%20multiple%20pivot%20tables%20on%20a%20dashboard%2C%20exporting%20to%20Excel%20always%20exports%20the%20first%20table%2C%20regardless%20of%20which%20one%20you%20select.%20This%20happens%20because%20the%20export%20function%20targets%20the%20first%20matching%20table%20in%20the%20DOM%2C%20not%20the%20one%20you%20clicked%20on.%20There%20are%20currently%20no%20workarounds%20or%20configuration%20options%20to%20change%20this%20behavior%2C%20and%20it%20is%20confirmed%20to%20affect%20the%20latest%20master/dev%20version%C2%A0%5Bdetails%5D%28https%3A//github.com/apa che/superset/issues/34792%29.%0A%0AIf%20your%20issue%20is%20different%20%28for%20example%2C%20no%20file%20is%20generated%20at%20all%2C%20or%20the%20file%20is%20corrupt%29%2C%20please%20check%20your%20browser%20console%20for%20JavaScript%20errors%20or%20Superset%20logs%20for%20Python%20stack%20traces%2C%20as%20there%20could%20be%20an%20additional%20problem.%20If%20you%20can%20share%20any%20error%20messages%20or%20logs%2C%20that%20would%20help%20narrow%20it%20down.%0A%0AThe%20CSV%20export%20works%20because%20it%20uses%20a%20different%20code%20path%20and%20does%20not%20try%20to%20preserve%20the%20pivot%20structure.%20The%20Excel%20export%20is%20intended%20to%20keep%20the%20multi-level%20column%20structure%2C%20but%20this%20bug%20prevents%20it%20from%20working%20reliably%20in%20dashboards%20with%20multiple%20pivot%20tables%C2%A0%5Bfeature%20background%5D%28https%3A//github.com/apache/superset/pull/33569%29.%0A%0ALet%20me%20know%20if%20you%20see%20a%20different%20failure%20mode%20or%20ha ve%20error%20details%E2%80%94I%27m%20happy%20to%20help%20interpret%20them.) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/36944) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
