Forum Discussion

Lawliim's avatar
Lawliim
Icon for Advocate I rankAdvocate I
11 months ago
Solved

Unable to connect to Google Bigquery data source (October 2025) due to ADBC US location error.

Due to most likely a patch for this build related to Google Bigquery I am now unable to connect to my europe-north1 based projects. The cause seems to be that the Google Bigquery source automatically...
  • v-kpoloju-msft's avatar
    11 months ago

    Hi Lawliim,

    Thank you for reaching out to the Microsoft Fabric Community Forum and yes, you are right that this seems to have started after the recent Power BI October 2025 update. Also, thanks to grazitti_sapna, for his inputs on this thread.

    Based on the error message (Dataset ... was not found in location US), it looks like Power BI’s Google Big Query connector (ADBC-based) is defaulting to the US region, even when your dataset is stored in a regional location (such as europe-north1).

    This behaviour has been reported by other users as well and appears to be a known issue with the latest connector build. You can try the following steps while Microsoft and Google work on a fix:

    Switch back to the legacy connector: Go to File > Options and settings > Options > Preview features, uncheck “Use ADBC-based Big Query connector”, Restart Power BI Desktop and reconnect to your dataset.

    If the issue persists, you can temporarily connect using the ODBC driver (Simba Big Query) as a workaround. Check your dataset’s region in the Google Cloud Console to confirm the exact location Power BI currently needs the connector to match that region correctly.

    You can refer this solved thread: https://community.fabric.microsoft.com/t5/Power-Query/Power-BI-BigQuery-Connector-Fails-for-Regional-Datasets-us-west2/m-p/4830273 

    For connector reference, refer this official Microsoft link: https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery 

    Hope this helps clarify the situation and gives you a working path until an update is released.
    Thank you for using the Microsoft Fabric Community Forum.