Data connection failure

 
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