I am getting the above error while loading the data into appsheet from google sheets. Data is loaded from BigQuery and has just less than 5000 rows. Is their a limitation for number of rows in appsheet. How do I resolve this issue?
That’s not the reason. By any chance.. have you modified your sheet names by mistake and they don’t match anymore with the app? Has the app worked earlier?
1 Like
The app has not worked at all. I have created the app multiple times with different google sheets (but has same data).
Do you mean that this app has never worked?
Yes
The sheet I am using in Appsheet is a connected sheet. Is that a concern while loading the data into appsheet?
Loading the data should not have anything to do with this. Are you able to show how the sheet is constructed.. like the first few rows?
Have you modified your sheet names in the spreadsheet? It’s worth to double check them all one by one.
No I have not modified anything. One thing is that when I am trying to load other sheets which are extracted from big query. I am not able to load any of them. Is it something to do with the permissions?
No, it should not have anything to do either. Try to create a brand new blank spreadsheet without any data, reassign that in your app and see if that works.
Its working with spreadsheets not connected with BigQuery. It is not getting connected with only sheets that are linked to BigQuery