LinkedIn
Twitter
for all my tables the datasource has dropped off, all tables say โ- select data source -โ
I can browse for more data, select my google account, browse for the file, select it, I then see โprocessingโ dots but then my screen returns to this:
ie: the new data does not select and my tables have no source selected. there does not seem to be a way to select the data.
all of my tables are contained in a single workbook on google drive
Hi Lance,
Weโve identified an issue for XLSX spreadsheets stored on Google Drive, and maybe that is what you are observing.
When someone opens an XSLX file using Google Sheets (โOpen with Google Sheetsโ) and then makes an edit, the XLSX file is broken for Google Drive, but not for Google Sheets. If you try to reopen the XLSX file through Google Drive, you may see the following error:
This can impact you directly and your AppSheet app will not be functional. As it canโt reach the data source, youโll see a 500 error. If you donโt edit the XLSX spreadsheet directly, you should not see that issue.
For now, there are 2 solutions available to you to fix this issue:
- Save the corrupted XSLX into a GSheet and connect your app to that GSheet
- Save the corrupted XSLX into a GSheet, download that GSheet as XLSX, upload it once more to GDrive and connect to that XLSX. However with this solution, if you edit your XLSX spreadsheet, your app will get into a broken state again.
Weโve reached out to the appropriate team within Google to look into the issue. Weโll let you know when we know more.
Thank you
