Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Bigquery connection error

Hi, I get the following message when attempting to connect to my bigquery database:

ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate. ERROR [HY000] [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate.

 

The weird thing is that it is pretty random when I get the message. Sometimes the connection works perfectly for an entire day, and then does not work the next day (without any changes to the pbix file except refreshing). Sometimes it even starts out fine and then breaks in the middle of the refresh with the same error message.

 

I have checked all the existing boards without finding anything that helps, including permission rights (my user is the owner and admin of all projects), and my connection (I have tried many different networks). I have also asked others within my organisation to try and connect from their PBI desktop - and they experience the same inconsistent error. 

 

Any ideas to what the error is or what it means in relation to my connection?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

It seems that the solution proposed by microsoft support works:

In PBI Desktop open the report and goto to "Transform data" -> "Advanced Editor".
2. Add command timeout value such as:
Source = GoogleBigQuery.Database([CommandTimeout=#duration(0, 0, 30, 0)]),

View solution in original post

6 REPLIES 6
rafael-b
Frequent Visitor

I have the exact same problem.

The solution proposed here did not work. What worked for me was either refreshing manually one table at a time or using the July version. 

Anonymous
Not applicable

It seems that the solution proposed by microsoft support works:

In PBI Desktop open the report and goto to "Transform data" -> "Advanced Editor".
2. Add command timeout value such as:
Source = GoogleBigQuery.Database([CommandTimeout=#duration(0, 0, 30, 0)]),

amitchandak
Super User
Super User

@Anonymous , You might to import SSL certificate - https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

 

One open issue - https://community.powerbi.com/t5/Issues/Problems-with-native-connection-Google-Big-Query/idi-p/1179424

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thanks a lot for your help! I also read the other thread with the same issues, but they did not find any solution. But it sounds very plausible that it is a problem with cerficates. However, I cannot find anywhere in PowerBI Desktop where you can install certificates - the link was about sql server. Can you help me to where the connection certificates are actually stored? Thanks a lot....

Hi @Anonymous ,

 

Try to use "Google BigQuery" connector.

Connect to a Google BigQuery database in Power BI Desktop 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

no

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.