Forum Discussion

sparrow0hawk's avatar
sparrow0hawk
New Member
1 year ago
Solved

Unable to connect to Google BigQuery data source (August 2025 build)

I am attempting to get data from Google BigQuery using the Get Data modal. After selecting "Google BigQuery" and clicking connect it opens a new modal for setting "Advanced options" if I leave these ...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi sparrow0hawk 

    This is the new BigQuery connector (ADBC, Preview) causing the odd auth flow. Two easy ways to unblock:

    Quick fix (use the old flow):

    • Power BI Desktop >> File >> Options >> Preview features >> uncheck “Use new Google BigQuery connector implementation” >> restart.

    • Then Data Source Settings >> Clear Permissions and connect again you’ll get the old Organizational / Service Account sign-in screens.

    If you stay on the new connector:

    • Make sure you’re on 64-bit Desktop (required for the preview). 

    • Connect again; you should see Organizational or Service Account sign-in. For service accounts, paste the JSON key as a single line (no line breaks) or it fails. 

    If you still don’t get a sign-in prompt after that, clear credentials again and try the Google BigQuery (Microsoft Entra ID) connector for org login.

    https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery 
    https://powerbi.microsoft.com/en-us/blog/power-bi-may-2025-feature-summary/?utm 

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Hi sparrow0hawk 

This is the new BigQuery connector (ADBC, Preview) causing the odd auth flow. Two easy ways to unblock:

Quick fix (use the old flow):

  • Power BI Desktop >> File >> Options >> Preview features >> uncheck “Use new Google BigQuery connector implementation” >> restart.

  • Then Data Source Settings >> Clear Permissions and connect again you’ll get the old Organizational / Service Account sign-in screens.

If you stay on the new connector:

  • Make sure you’re on 64-bit Desktop (required for the preview). 

  • Connect again; you should see Organizational or Service Account sign-in. For service accounts, paste the JSON key as a single line (no line breaks) or it fails. 

If you still don’t get a sign-in prompt after that, clear credentials again and try the Google BigQuery (Microsoft Entra ID) connector for org login.

https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery 
https://powerbi.microsoft.com/en-us/blog/power-bi-may-2025-feature-summary/?utm