Problems with Location in PowerBi Desktop

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. ✅

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.