Forum Discussion
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 specifi...
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)]),
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.