Problems with Location in PowerBi Desktop

[EmilMar]

We have a problem when we connect PowerBI Desktop with our DWH.

Our DWH Data are europe-west6

When I connect PowerBI with DWH the tool takes location USA. That’s why I have this error.

Can you please tell me how can I change the location in PowerBi? USA as location now is wrong

Thanks a lot in advance!

[anilelmastasi · Accepted solution]

Hello @EmilMar ,

When you click Get data and selecting Google BigQuery, could you please expand “Advanced options” in the connection window before loading data? After that, in the Billing project ID field, enter the same project where your dataset resides.

If this solved your issue, please mark it as the accepted solution. ✅

[v-pnaroju-msft · Accepted solution]

Thankyou, @anilelmastasi, for your response.

Hi EmilMar,

We appreciate your enquiry via the Microsoft Fabric Community Forum.

Based on my understanding, the issue arises because the new Power BI BigQuery connector occasionally initiates jobs without specifying a region. In such cases, BigQuery defaults the job location to US, which leads to errors when the dataset is located in europe-west6. In short, the Power BI BigQuery connector defaults queries or jobs to the US region if a region is not explicitly specified, causing a mismatch with the dataset location.

Please follow the steps below, which may help resolve the issue:

1. In Power BI Desktop, navigate to File > Options and settings > Options > Preview features, uncheck Use new Google BigQuery connector implementation, and then restart the application.
2. Open Transform Data > Advanced Editor and remove Implementation=2.0 from the M query.
3. Optionally, specify a billing project explicitly in the M code, for example:
   Source = GoogleBigQuery.Database([BillingProject="yourprojectid"])

Additionally, please refer to the link below for further information:
Google BigQuery connector - Power Query | Microsoft Learn

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.

[EmilMar]

Thank you so much! You helped me a lot! it works now. i can nonnect power bi desktop with big query. THANKS!

[anilelmastasi · Accepted solution]

Hello @EmilMar ,

When you click Get data and selecting Google BigQuery, could you please expand “Advanced options” in the connection window before loading data? After that, in the Billing project ID field, enter the same project where your dataset resides.

If this solved your issue, please mark it as the accepted solution. ✅

[EmilMar]

THANKS a lot!