Data Refresh Error: "Cannot enable SSL" for BigQuery data source

[LKemp10]

For several months I have now been experiencing intermittent issues when trying to refresh my report's data from within PBI desktop - scheduled refreshes from within the web version of PBI work fine most of the time. The data for my report comes from a view in BigQuery. I would typically expect to see ~50million rows in acomplete refresh, however I consistently get to 2-10million rows before getting the following error message:

OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.

Up until now I have been able to force the refresh, by simply retrying several times until the entire dataset eventually refreshes in one go. However, now even this approach is failing, and I am consistently seeing this error whenever I attempt to refresh. How do I resolve this issue and ensure that my dataset will refresh consistently in PBI desktop? 

Thanks

[v-alq-msft]

Hi, @LKemp10 

You may try to go to Home -> Edit Queries -> Data source settings.

Then you may select the data source from the list and click Edit Permissions. Disable the Encryption like below.

Besides, you need to check if the SSL protocol version that is lower than what is allowed for the connection as what is suggested in the error message. You may also refer to the document for further help.

Best Regards

Allan

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