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

 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.

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.

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.