Issue referching dataset connected to Big Query on local desktop

[Anonymous]

Hi Friends,

For last 2 days I am struck with the below error, whenever I am tryign to refersh the entire dataset connected to Big query from my local, I was able to do this 2 days prior but not sure what has changed and I am gettign this error now.
"ODBC: 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."

If I go into Power Bi editor, I can see the previews for all tables loading without any errors and when I click close and apply this error comes up. If I refersh table by table then it refershes without any issues. Can anyone please suggest if you have come across this issue earlier.

[rafael-b]

I also have this issue.

1) Was running the October version, tried manually refreshing each table instead of all simultaneously and it worked.

2) Still on the October version, tried completely disabling the firewall and it did not work.

3) Tried the July desktop version and the parallel refresh finally worked.

[Cauhi · Accepted solution]

I was able to solve it with either of these two ways:

1. Download the June version of PowerBI: https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-d...

or

2. Remove the parallel update: file > options and settings > options > current file > data load > parallel loading of tables > one (disable parallel loading)

[Anonymous]

Thanks @Cauhi I tried with option 2 and it worked. I might try option 1 as wellthat way, i can still do a parallel load. Hopefully the next release sould fix this issue for me :).

[rajendraongole1]

Hi @Anonymous -The error is likely due to a mismatch between SSL settings or an issue with the TLS version compatibility between Power BI and BigQuery. By verifying and adjusting the SSL configuration in your ODBC settings and ensuring compatibility with the TLS version, you should be able to resolve the issue. If the server supports only older versions of TLS, you might need to update the server configuration or adjust your client's SSL settings (if possible).

you might need to check the SSL settings in the ODBC Data Source Administrator (ODBC DSN setup). Make sure that SSL is enabled only if your BigQuery server supports it.

still issue exist connect with network settings team check if there is any recent changes have been made to your network configuration, firewall, or proxy settings that might be affecting the SSL connection to BigQuery and consulting support teams 

Hope the above information helps.

[Anonymous]

Thanks for the response @rajendraongole1, I am not using a ODBC connection for connecting to BQ, I am using the native driver of Power BI to connect, so not sure which settings I need to change to fix this. I tried uninstall and install teh Power Bi app to fix this issue but no luck.