Forum Discussion
Google Big Query Connector - May 25 Release
Hi Dilbertfan,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks Akash_Varuna, for those valuable insights for this thread. I have identified several alternative workarounds that may assist in resolving the thread.
Based on the error you're encountering:
ADBC: Status(StatusCode="Internal", Detail="Bad gRPC response. Response protocol downgraded to HTTP/1.1"),
This relates to the newly introduced Google Big Query connector using ADBC, which was released in Power BI Desktop’s May 2025 update and is currently in Preview. The ADBC-based connector utilizes gRPC over HTTP/2, providing enhanced performance and modern protocol advantages. However, it requires network environments that support HTTP/2. The error suggests that gRPC is reverting to HTTP/1.1, which the new connector does not support, resulting in the failure.As the connector is currently in Preview, you may option to use the legacy version:
- Go to File > Options and settings > Options > Preview Features
- Uncheck: "Use ADBC-based Big Query connector"
- Restart Power BI Desktop
- This will revert to the previous (ODBC-based) connector, which does not rely on HTTP/2.
If continuing with the Preview connector: Please ensure the following network conditions: HTTP/2 support is enabled end-to-end. No TLS/SSL inspection or proxy is downgrading HTTP/2 to HTTP/1.1
Whitelist the following domains:
- *.googleapis.com
- bigquery.googleapis.com
- oauth2.googleapis.com
These changes may require assistance from your IT/network team.
Kindly please refer to the below mentioned link for better understanding and more information:
Google Big Query connector - Power Query | Microsoft Learn
Compare gRPC services with HTTP APIs | Microsoft LearnIf this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Hi Dilbertfan,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks Akash_Varuna, for those valuable insights for this thread. I have identified several alternative workarounds that may assist in resolving the thread.
Based on the error you're encountering:
ADBC: Status(StatusCode="Internal", Detail="Bad gRPC response. Response protocol downgraded to HTTP/1.1"),
This relates to the newly introduced Google Big Query connector using ADBC, which was released in Power BI Desktop’s May 2025 update and is currently in Preview. The ADBC-based connector utilizes gRPC over HTTP/2, providing enhanced performance and modern protocol advantages. However, it requires network environments that support HTTP/2. The error suggests that gRPC is reverting to HTTP/1.1, which the new connector does not support, resulting in the failure.
As the connector is currently in Preview, you may option to use the legacy version:
- Go to File > Options and settings > Options > Preview Features
- Uncheck: "Use ADBC-based Big Query connector"
- Restart Power BI Desktop
- This will revert to the previous (ODBC-based) connector, which does not rely on HTTP/2.
If continuing with the Preview connector: Please ensure the following network conditions: HTTP/2 support is enabled end-to-end. No TLS/SSL inspection or proxy is downgrading HTTP/2 to HTTP/1.1
Whitelist the following domains:
- *.googleapis.com
- bigquery.googleapis.com
- oauth2.googleapis.com
These changes may require assistance from your IT/network team.
Kindly please refer to the below mentioned link for better understanding and more information:
Google Big Query connector - Power Query | Microsoft Learn
Compare gRPC services with HTTP APIs | Microsoft Learn
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Thank you v-kpoloju-msft for taking the time to give me a detailed response and will take everything on board.
I know that the bigquery end points are white listed, but not sure about the HTTP/2. Will look into that - this was the bit that I was unsure of whether it was a driver or network issue, but seemingly the latter.
The reason we are using the new connector is we have always had problems with the legacy connector and never been able to connect properly, despite all end points white listed and correct access permissions. Even with support from Microsoft we can't get it to access the Big Query datasets - we got further with the new connector; we could at least see the datasets 🙂
The Big Query connector v2 implementation fails to connect with any BQ table views, which renders the connector useless. Reverting to the v1 connector fixes our workflows... but why is v2 failing when none of the inputs have changed? The error we get is:
DataSource.Error: ADBC: Could not create dataset _bqadbc_temp_tables
