One of my app is having trouble downloading data from a partition table. My users are able to view the data after changing source in the user settings but I can’t quite figure why export returns 0 data. Appreciate your inputs. ![]()
Hello @songoku82,
I’ve looked into this and found that exporting from partitioned tables can sometimes be tricky depending on how the export action is configured. Here are a few things to check that might resolve the issue::
- Verify Active Partition: Ensure the user settings are correctly set before triggering the export action.
- Use Specialized Actions: Ensure you are using the “Export this view to a CSV file” action, which generally respects the currently displayed view better than broader export tools.
- Check for Identical Structure: Data partitions must have identical column structures. If one partition has different columns (due to accidental edits), exports can fail.
- Use Alternative Export Methods: If direct CSV export fails, consider using Apps Script to aggregate data from multiple sheets into a single master sheet for exporting.
- Remove Old Connections: If you have updated your partitions, ensure old data connections are fully removed, as AppSheet might still reference old sheets.
Also, I found this article with further information, at the bottom you will also find a link to reach out to the support team in case it is needed:
I hope this helps!