Forum Discussion

cgapmmg's avatar
cgapmmg
Frequent Visitor
1 year ago
Solved

Gateway stopped working - SSL certificate error

Hi, We were using the on-premises data gateway to refresh our dashboards, but in December 2024, it stopped working, and I haven't been able to make it work again. I use an Impala database, as I alw...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hello cgapmmg,

     

    If you still face the issue then please consider raising a support ticket for further assistance.This will allow the engineering team to investigate the issue in detail and provide a resolution or guidance.

     

    To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    Thankyou for your understanding.

  • cgapmmg's avatar
    cgapmmg
    1 year ago

    I solved it by adding the parameter AllowSelfSignedServerCert = 1 to the microsoft.impalaodbc.ini file, and that fixed the issue.

     

    I was getting the error:
    ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect
    This happened after a server update, which now uses a self-signed certificate. I found that unless AllowSelfSignedServerCert is explicitly set to 1 in the microsoft.impalaodbc.ini file, the Microsoft Impala ODBC driver assumes a default value of 0, which causes the SSL certificate verification to fail.

     

    Now my gateway is running fine.
    Thanks to everyone who tried to help!

cgapmmg's avatar
cgapmmg
Frequent Visitor
1 year ago

Hi,

 

The certificate is placed in the Trusted Root Certificarion Authorities, both under the certmgr.msc and certml.msc.
The account has the access, since the project runs normally in Power BI Desktop. The issue is only when I try to create the connection.

I've contacted the database manager and IT manager, to check if the issue is on the database or proxy/firewall.

But, since I can connect to the DB normally on PBI Desktop, I have to think that the problem is on PBI Service 

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi  cgapmmg,

    Thank you for reaching out to the Microsoft Fabric Community forum.

     

    Ensure the data source configuration in Power BI Service matches Power BI Desktop, including connection strings, server names, and database names.

    Update the on-premises data gateway to the latest version to avoid connectivity issues.

    Confirm and re-enter correct credentials in Power BI Service under dataset settings if needed.

     

    Regards,
    Sahasra.

    • v-sgandrathi's avatar
      v-sgandrathi
      Community Support
      1 year ago

      Hi cgapmmg,

       

      May I ask if you have gotten this issue resolved?

      If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

       

      Thanks for using Microsoft Fabric Community Forum.

      • v-sgandrathi's avatar
        v-sgandrathi
        Community Support
        1 year ago

        Hi cgapmmg,

         

        May I ask if you have gotten this issue resolved?

        If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

        Thanks for using Microsoft Fabric Community Forum.