I am using a connected sheet which has the data from BigQuery into GoogleSheets. It refreshes once every hour. I am trying to use this data to create an app in appsheet. I have created the app multiple times with this data but I am always getting ERROR 400. How to resolve the issue and load the data without any error into appsheet?
Have you tried mirroring the “Connected Sheet1” to another Spreadsheet Tab using formulas and use the other Tab as your AppSheet datasource? I think what’s happening here is everytime your Connected Sheet1 updates every hour the Column arrangements and Data type changes and this could affect the current table you’re using AppSheet as the data source.
Yes, I tried using ImportRange function in GoogleSheets but it is not working. It is giving “ErrorCircular dependency detected. To resolve with iterative calculation, see File > Settings.” this error or Data Parsing error everytime I tried.
I have also used appscript but it is also giving an error saying that it is not possible because the source sheet is connected to another dataset (bigquery in my case)
Is their a way to get the source data into another spreadsheet using formulas. I have around 5000 rows and 6 columns and the data should be dynamic in nature.
You can user the Query function instead in Sheets =Query(Range,[Query you’d like to run])
QUERY is not available for connected data. Please create an extract from the connected sheet and apply the function to the extracted data.
I am getting the above error if I am using the Query function in Google Sheets. The data should be dynamic and should get updated whenever there is a change in Big Query. Is their any other way of resolving this.
