Cob_Adm1's avatar
Cob_Adm1
Regular Visitor
4 years ago
Status:
Investigating

NEW BUG: Bigquery connection error - DataSource.Error: ODBC: ERROR [42000] [Microsoft][DSI]

Hi All,   I have some qeird error in my PowerBI. When I try to connect to the bigqeury views I get this error:   DataSource.Error: ODBC: ERROR [42000] [Microsoft][DSI] An error occurred while att...
APIS and Embedding
Data Modeling
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago
Status changed:
New
to
Needs Info

Similar issue had been submited previously(ICM: 275695111), wants to collect more information about this issue:

  1. Whether this issue happens in Google BigQuery connector, not ODBC connection
  2. Power BI Desktop version
  3. Has this ever worked before?

 

In addition, for information 1, if this issue only happens in Google BigQuery connector, have you tried to use ODBC connector to connect to the same table in the same source to check this issue, see:

ODBC and JDBC drivers for BigQuery  

 

When using Google BigQuery connector, whether it has error like below for a table while using ODBC connection could show the data normally?

 

Best Regards,
Community Support Team _ Yingjie Li

Completed Ideas