dosubot[bot] commented on issue #35139: URL: https://github.com/apache/superset/issues/35139#issuecomment-3583542072
<!-- Answer --> The 50k Excel export limit is almost always due to the row_limit value saved in the chart’s own settings, not a backend hardcoded cap. Even if you set ROW_LIMIT or SQL_MAX_ROW higher in your config, the standard “Export to Excel” option uses whatever row_limit is in the chart’s form data. Only “Export to full Excel” (enabled by ALLOW_FULL_CSV_EXPORT) overrides this and uses the higher config value. To fix: edit the chart, set the row limit control to your desired value (e.g., 500,000 or more), save, and then export to Excel again. If you want to bypass all limits, use “Export to full Excel” (make sure the feature flag is enabled). If you’re using server pagination, disable it—pagination restricts exports to the visible page only. If config changes don’t take effect, try restarting Superset and rebuilding the frontend to clear any cached form data. For more details, see [this code reference](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/dashboard/components/gridComponents/Chart.jsx#L153-L401) and [this discussion](https://github.com/apache/superset/discussions/31467). If you still hit limits, check the logs for errors or timeouts, and consider exporting as CSV (which is less restrictive) or splitting the export into chunks as a workaround. <!-- 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/afbf0110-63b7-477e-a3d6-5466ea3721fb?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/afbf0110-63b7-477e-a3d6-5466ea3721fb?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/afbf0110-63b7-477e-a3d6-5466ea3721fb?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/afbf0110-63b7-477e-a3d6-5466ea3721fb?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/afbf0110-63b7-477e-a3d6-5466ea3721fb?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/afbf0110-63b7-477e-a3d6-5466ea3721fb?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/afbf0110-63b7-477e-a3d6-5466ea3721fb?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=The%2050k%20Excel%20export%20limit%20is%20almost%20always%20due%20to%20the%20row_limit%20value%20saved%20in%20the%20chart%E2%80%99s%20own%20settings%2C%20not%20a%20backend%20hardcoded%20cap.%20Even%20if%20you%20set%20ROW_LIMIT%20or%20SQL_MAX_ROW%20higher%20in%20your%20config%2C%20the%20standard%20%E2%80%9CExport%20to%20Excel%E2%80%9D%20option%20uses%20whatever%20row_limit%20is%20in%20the%20chart%E2%80%99s%20form%20data.%20Only%20%E2%80%9CExport%20to%20full%20Excel%E2%80%9D%20%28enabled%20by%20ALLOW_FULL_CSV_EXPORT%29%20overrides%20this%20and%20uses%20the%20higher%20config%20value.%0A%0ATo%20fix%3A%20edit%20the%20chart%2C%20set%20the%20row%20limit%20control%20to%20your%20desired%20value%20%28e.g.%2C%20500%2C000%20or%20more%29%2C%20save%2C%20and%20th en%20export%20to%20Excel%20again.%20If%20you%20want%20to%20bypass%20all%20limits%2C%20use%20%E2%80%9CExport%20to%20full%20Excel%E2%80%9D%20%28make%20sure%20the%20feature%20flag%20is%20enabled%29.%20If%20you%E2%80%99re%20using%20server%20pagination%2C%20disable%20it%E2%80%94pagination%20restricts%20exports%20to%20the%20visible%20page%20only.%20If%20config%20changes%20don%E2%80%99t%20take%20effect%2C%20try%20restarting%20Superset%20and%20rebuilding%20the%20frontend%20to%20clear%20any%20cached%20form%20data.%20For%20more%20details%2C%20see%20%5Bthis%20code%20reference%5D%28https%3A//github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset-frontend/src/dashboard/components/gridComponents/Chart.jsx%23L153-L401%29%20and%20%5Bthis%20discussion%5D%28https%3A//github.com/apache/superset/discussions/31467%29.%0A%0AIf%20you%20still%20hit%20limits%2C%20check%20the%20logs%20for%20errors%20or%20timeouts%2C%20and%20consider%20exporting%20as%20CSV%20%28which%20is%20less%20r estrictive%29%20or%20splitting%20the%20export%20into%20chunks%20as%20a%20workaround.) [](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/35139) -- 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]
