Data connection failure

[StefcoAE]

Hi all,

I have a connection with bigquery and i was always able to refresh my models on the desktop without any problems. Now i get the error message i send below. I have tryed a lot to fix it but without result:

- Uninstal and instal

- Settings the same as collega and same dataset (no result)

- Changing permissions.

 

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.

 

Does someone know the fix for this??

[Anonymous]

Hi @StefcoAE 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @StefcoAE 
I wanted to check if you had the opportunity to review the information provided by @johnbasha33 . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

 Hi @StefcoAE 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[johnbasha33]

 
Hi,This error indicates an SSL/TLS mismatch between your Power BI desktop connection and your Google BigQuery server. It usually happens due to recent security updates, driver issues, or changes in BigQuery settings.

Possible Fixes:

1. Update the ODBC Driver for BigQuery

Ensure that you are using the latest ODBC driver for BigQuery from Google:

• Download the latest driver from Google’s official site

• Install the driver and restart Power BI.
  
  

  Verify TLS Version in Power BI and Registry

  Your connection requires TLS 1.2 or higher. Check if Power BI is using the correct protocol:

  • Open Registry Editor (Win + R → regedit)

  • Navigate to:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols

  • Ensure TLS 1.2 is enabled under both:

    • Client

    • Server

    • If missing, create a new DWORD value:

      • Name: Enabled

      • Value: 1

        Then restart your computer
        
        
        

        Manually Force SSL Mode in Connection String

        Try explicitly setting SSL=0 or SSL=1 in your connection settings:

        1. Go to Power BI Desktop → Transform Data → Data Source Settings.

        2. Select your BigQuery connection → Edit Permissions.

        3. Click Advanced Editor and modify the connection string:

           makefile

           CopyEdit

           Driver={Simba ODBC Driver for Google BigQuery}; SSL=0; ...

           If SSL=0 doesn’t work, try SSL=1.



           Check BigQuery SSL Settings

           • If your BigQuery server requires SSL, ensure your Power BI is connecting via SSL.

           • If BigQuery doesn’t require SSL, ensure that Power BI is not forcing an SSL connection.

           • You can verify this in Google Cloud Console under IAM & Admin > SSL settings.
             
             

             Change Power BI Authentication Method

             Sometimes, changing authentication methods helps:

             • In Power BI Desktop → Data Source Settings.

             • Click Edit Permissions and change authentication to:

               • OAuth

               • Service Account JSON Key

               • Google Credentials

               • Try reconnecting.

               • Restart Power BI and try again.

               • Test the connection in another BI tool (Tableau, DBeaver) to confirm if the issue is Power BI-specific.

               • Check if your colleagues have the same issue (recent company-wide changes?).
                 
                 

                 Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

@StefcoAE