PowerBI connection to non-US bigquery dataset

[burkhard]

I have a bigquery dataset that is located in europe-west3. I can authenticate via google account or service account, both works. It shows my datasets. Yet, when i try to open a dataset to see my tables, i get the following error:

DataSource.Error: ADBC: Cannot execute <ExecuteQueryInternalAsync>b__1 after 5 tries. Last exception: The service bigquery has thrown an exception. No HttpStatusCode was specified. Job example-project-id/US/job_ab61dee2_8b4a_41d2_99ea_c5fda23d0651 contained 2 error(s). First error message: Not found: Dataset example-project-id:example_data_set was not found in location US

Details:

DataSourceKind=GoogleBigQuery

DataSourcePath=GoogleBigQuery

AdbcStatus=1

It looks like it is trying to search for a dataset in the US location. But i cannot find a way to change this behavior to look in location europe-west3. Has anyone had the same issue? How did you solve it? Moving the dataset to US is not an option unfortunately.

Any advice is greatly appreciated. Thanks!

[v-pgoloju]

Hi @burkhard,

Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

If the issue was resolved through the support ticket, it would be great if you could share the solution here as well. It could really help other community members find answers more quickly.

Warm regards,
Prasanna Kumar

[dseelam1]

I am also getting same error message. I have updated the "Preview features" and modified "Implementation" as suggested in previous posts. Still getting below error.

"DataSource.Error: ADBC: Cannot execute <ExecuteQueryInternalAsync>b__1 after 5 tries. Last exception: The service bigquery has thrown an exception. No HttpStatusCode was specified. Job ORG-data-ProjectUK/US/job_f778c530_543c_4270_8335_802bd5c0d5ee contained 2 error(s). First error message: Not found: Dataset ORG-data-ProjectUK:UK_Table was not found in location US
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
AdbcStatus=1
SQLState=
NativeError=0 "

[v-pgoloju]

Hi @dseelam1,

If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Thanks & Regards,

Prasanna kumar

[v-pgoloju]

Hi @burkhard,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @TINOMAABBEY, @GrowthNatives, @DianaMaria, and @Hofmann  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Hofmann]

I experienced the same issue, but disabling the new Google BigQuery connector implementation resolved the issue. 
Go to Options and settings (under the File tab) > Options > Preview features, and then select the checkbox to disable the Use new Google BigQuery connector implementation option.

[TINOMAABBEY]

This worked for me, thanks

[DianaMaria]

Hello. 
Go to Setting > Options > Preview features, and disable Use new Google BigQuery connector implementation option.
And after that, for the source already implement ,try to modifiy in source Implementation= null instead of Implementation= "2.0"

[GrowthNatives]

Hello @burkhard & @Patryk_Matera , 
To solve this issue that you are facing with location 
You can try using Simba ODBC driver by following these steps :
1. Download the Simba ODBC driver for BigQuery from Google
2. Go to System DSN → Add → Simba ODBC Driver for Google BigQuery.
3. Fill in the Details - Project Id: your-project-id

Dataset Id: your-dataset-id 

Location: europe-west3

4.  In Power BI Desktop → Get Data → ODBC.

Select your required DSN .


⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]

[Patryk_Matera]

Currently, I'm trying to figure out the same problem and haven't found a solution yet. Let me know when you find one.

[TINOMAABBEY]

Go to Options and settings (under the File tab) > Options > Preview features, and then select the checkbox> Use new Google BigQuery connector implementation option. Disable it. I disabled it and it worked for me