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 

shashiPaul1570_'s avatar
shashiPaul1570_
Icon for Responsive Resident rankResponsive Resident
1 year ago

Hi sparrow0hawk

The 401 “missing credential” error usually comes up because Desktop isn’t launching the Google OAuth prompt. A few things you can try:

  • Go to Data source settings → Global permissions, clear any saved BigQuery/Google credentials.

  • In Desktop Options, enable “Use my default web browser”, then retry so the OAuth login window opens properly.

  • If your tenant requires it, set the Billing project under Advanced options.

  • Alternatively, you can connect with a service account JSON (make sure the account has BigQuery Data Viewer + Job User roles).

  • If none of that works in the August 2025 build, install the July 2025 Power BI Desktop as a temporary workaround — this looks like a regression in the new dialog.

    You can also find these links for more help
    https://stackoverflow.com/questions/79036379/power-bi-issue-refreshing-bigquery-data-sources-error-hy000-microsoftdrive?utm 

Google BigQuery (Microsoft Entra ID)

https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery-aad 

Hope this helps resolve the issue! 👍
If it works, please don’t forget to give Kudos and mark this as Accepted Solution so others can benefit. ✅

 

Best Regards,
Shashi Paul