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)]),
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