Error downloading data from a partition table

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. :thinking:

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::

  1. Verify Active Partition: Ensure the user settings are correctly set before triggering the export action.
  2. 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.
  3. Check for Identical Structure: Data partitions must have identical column structures. If one partition has different columns (due to accidental edits), exports can fail.
  4. 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.
  5. 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!