Forum Discussion

naphob's avatar
naphob
Regular Visitor
1 year ago
Solved

Data connection issues with Google Big query

Hello everybody, Currently I am having issue connecting to a data source from Google Bigquery, but it is throwing up an Error DataSource.Error: ADBC: UnknownError [] Cannot execute <ExecuteQueryI...
Need Help
  • agomez_binni's avatar
    agomez_binni
    1 year ago

    We found that problem. We haven't found the solution to the problem while using the new ADBC connector. If ADBC is disabled it uses ODBC and works again. Can enable/disable here: To access this feature in Power BI Desktop, navigate to Options and settings (under the File tab) > Options > Preview features, and then select the checkbox to enable the Use new Google BigQuery connector implementation option. Once the option is on, all the newly created connections automatically use the new connector implementation.

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

Hi naphob 

 

This error often comes from setup or permission mismatches. Try these:

  1. Make sure BigQuery API is enabled and your service account has BigQuery Data Viewer + Job User roles.

  2. Use the correct JSON key in Power BI and set the Billing Project ID and Location (US/EU).

  3. Clear cached credentials in Power BI and reconnect.

  4. Test with a simple query like SELECT 1 to confirm access.

  5. Update Power BI Desktop or the BigQuery driver if it’s outdated.