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.

naphob's avatar
naphob
Regular Visitor
1 year ago

Hello agomez_binni Thank you for suggesting an alternative method, this method worked for me as I updated Power BI desktop version and disable this Preview Feature. 

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi naphob , thanks for the update, glad it worked. If you have any other queries, please feel free to create a new post in the community. We are always happy to help.