Forum Discussion
Unable to connect to Google Bigquery data source (October 2025) due to ADBC US location error.
- 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/4830273For 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.
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.
- Lawliim11 months ago
Advocate I
Thank you, I raised a ticket and showed Support and they escalated to product as well, so hopefully it is fixed soon.
In the meantime the switch to the old connector worked and solved it for now! Thank you for showing me this, I didn't know that option existed.