GitHub user dosubot[bot] added a comment to the discussion: When the user selects Export to Excel from the download menu on page 3(or any other page) the system exports page 1 instead.
<!-- Answer --> Yes, when you enable server-side pagination in a Table chart, "Export to Excel" will export only the data from the currently displayed page—not the first page or the entire dataset. To enable server-side pagination: open the Table chart in Explore, find the "Server pagination" checkbox in the control panel, and check it. Once enabled, you can set the "Server Page Length" to control how many rows appear per page. This feature is experimental and may not be available for all chart types or databases. Note that with server-side pagination, only single-column sorting is supported in Table charts, and multi-column sorting is not fully implemented yet. If you want to export all data while server pagination is enabled, you need to set the `ALLOW_FULL_CSV_EXPORT` feature flag to `True` in your `superset_config.py` or via the `SUPERSET_FEATURE_ALLOW_FULL_CSV_EXPORT` environment variable. Be aware that exporting all data can impact server performance due to high memory or compute usage [[source](https://github.com/apache/superset/discussions/31467)]. <!-- 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/14129958-24a5-417b-88a1-84af413f338e?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/14129958-24a5-417b-88a1-84af413f338e?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/14129958-24a5-417b-88a1-84af413f338e?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/14129958-24a5-417b-88a1-84af413f338e?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/14129958-24a5-417b-88a1-84af413f338e?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/14129958-24a5-417b-88a1-84af413f338e?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/14129958-24a5-417b-88a1-84af413f338e?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=Yes%2C%20when%20you%20enable%20server-side%20pagination%20in%20a%20Table%20chart%2C%20%22Export%20to%20Excel%22%20will%20export%20only%20the%20data%20from%20the%20currently%20displayed%20page%E2%80%94not%20the%20first%20page%20or%20the%20entire%20dataset.%20%0A%0ATo%20enable%20server-side%20pagination%3A%20open%20the%20Table%20chart%20in%20Explore%2C%20find%20the%20%22Server%20pagination%22%20checkbox%20in%20the%20control%20panel%2C%20and%20check%20it.%20Once%20enabled%2C%20you%20can%20set%20the%20%22Server%20Page%20Length%22%20to%20control%20how%20many%20rows%20appear%20per%20page.%20This%20feature%20is%20experimental%20and%20may%20not%20be%20available%20for%20all%20chart%20types%20or%20databases.%20Note%20that%20with%20server-side%20pagination%2C%20 only%20single-column%20sorting%20is%20supported%20in%20Table%20charts%2C%20and%20multi-column%20sorting%20is%20not%20fully%20implemented%20yet.%0A%0AIf%20you%20want%20to%20export%20all%20data%20while%20server%20pagination%20is%20enabled%2C%20you%20need%20to%20set%20the%20%60ALLOW_FULL_CSV_EXPORT%60%20feature%20flag%20to%20%60True%60%20in%20your%20%60superset_config.py%60%20or%20via%20the%20%60SUPERSET_FEATURE_ALLOW_FULL_CSV_EXPORT%60%20environment%20variable.%20Be%20aware%20that%20exporting%20all%20data%20can%20impact%20server%20performance%20due%20to%20high%20memory%20or%20compute%20usage%20%5B%5Bsource%5D%28https%3A//github.com/apache/superset/discussions/31467%29%5D.) [](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/discussions/36748) GitHub link: https://github.com/apache/superset/discussions/36748#discussioncomment-15295874 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
