Problem connecting to Google BigQuery

[Anonymous]

Hi All, I tried connecting to Google Big Query to which I have access to through Power BI. I am getting this error:

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect.
ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect.
Details:
DataSourceKind=GoogleBigQuery
DataSourcePath=GoogleBigQuery
OdbcErrors=Table

Anyone else facing this issue? Kindly help me out. I am on a very rigid deadline.

@shacharbenor  @Anonymous 

Thanks and Regards,

Richa Jha

[Anonymous]

Did you ever manage to solve this problem Richa Jha? 🙂 

[Anonymous]

Hello,

Any news on this error?  How to fix the problem. 

[fudong]

Encounter the same problem. Did you find the solution?

[v-juanli-msft]

Hi @Anonymous 

Are the Google BigQuery database in the different server as Power BI Desktop?

Maybe you can also try to trust the CA cert on both machines.

SSL Security Error with Data Source

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[fudong]

May I know what’s the detailed steps?