BigQuery Data Source

AppSheet AppSheet Q&A
,
1

Hi,

I want to add BigQuery as a data source and followed this tutorial https://www.youtube.com/watch?v=pL8mugW24ic but keep getting the error: Invalid dataset ID: appsheettest123:Appsheet: Invalid BigQuery credential.

I’ve checked and tried multiple combinations but can’t seem to get the Dataset ID right according to the error, below I added some screenshots of the BigQuery project and dataset as well as what I entered on AppSheet, any help would be greatly appreciated!

Jaimy_0-1646343475334.png
Jaimy_0-1646343475334.png694×388 30.5 KB

Jaimy_1-1646343633822.png
Jaimy_1-1646343633822.png428×792 33.2 KB

2

I have figured out my mistake but now have this error

Jaimy_0-1646350915508.png
Jaimy_0-1646350915508.png421×1007 47.6 KB

Also fixed this with the help of this article https://help.appsheet.com/en/articles/5398107-using-data-from-google-bigquery-with-the-bigquery-data-source#h_8b4cdae4f2