DataSource.Error: ADBC: Dataset XXX was not found in location US

Hi Anonymous, 

According to google's docs: 

https://cloud.google.com/bigquery/docs/troubleshoot-queries#location_not_foundThis error returns when you refer to a dataset resource that doesn't exist, or when the location in the request does not match the location of the dataset.

To address this issue, specify the location of the dataset in the query or confirm that the dataset is available in the same location.

You might be able to explicitly specify the location of the dataset in the connection. 

There's also been other community posts about similar errors indicating some regression in the service: https://community.fabric.microsoft.com/t5/Service/Power-BI-Service-BigQuery-connector-failing-with/td-p/4815200

There is an active known issue for Google BigQuery right now: https://support.fabric.microsoft.com/known-issues/?product=Power%2520BI&active=true&fixed=true&sort=published&issueId=1563

Can you try reverting to the old implementation of the connector and see if that works? 

In Power BI Desktop go to File -> Options and settings -> Options -> Preview features and turn off “Use new Google BigQuery connector implementation,” then restart Desktop and reconnect. If your M query shows GoogleBigQuery.Database([Implementation="2.0"]), remove that flag. https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Hi tayloramy ,

I manage to solve this by:

1. Following your suggestion to reverting to old implementation (File -> Options and settings -> Options -> Preview features and turn off “Use new Google BigQuery connector implementation,” then restart Desktop and reconnect. If your M query shows GoogleBigQuery.Database([Implementation="2.0"]), remove that flag)
2. Setting the Billing Project Name. To get the billing project name, I go to https://console.cloud.google.com/iam-admin/settings , and take the Project ID specified there

Thanks!