Forum Discussion

Hemant707's avatar
Hemant707
New Member
4 years ago
Solved

Connecting postgres database for aws rds

while connecting to postgres database in power bi, it is showing error- "The remote certificate is invalid according to the validation procedure".

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Hemant707 ,

     

    For this type of error message, it is usually caused by a certificate conversion or import method error. Refer to the following similar solutions with detailed step-by-step instructions:

     

    If the problem is still not resolved, please provide detailed error information and related operation screenshoot. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Hemant707 ,

     

    For this type of error message, it is usually caused by a certificate conversion or import method error. Refer to the following similar solutions with detailed step-by-step instructions:

     

    If the problem is still not resolved, please provide detailed error information and related operation screenshoot. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Pilares's avatar
      Pilares
      Helper I
      3 years ago

      I've followed the steps, but still getting the "remote certificate" error. Using an ODBC connection works fine though.

       

      Regards, Frank van Zuilen

    • Pilares's avatar
      Pilares
      Helper I
      3 years ago

      Is there already a working solution available? I've tried above proposed solution, including using a qualified aws domain and physical ip address. The standard Postgres adapter in Power BI is still not working. There are no issues when connecting via database management tools, like PGAdmin or DBeaver, or other BI tools, like Qlik Sense.

       

      Regards Frank van Zuilen

    • Pilares's avatar
      Pilares
      Helper I
      3 years ago

      Hi v-henryk-mstf 've tried all the proposed solutions on this forum, including using a qualified aws domain and physical ip address. The standard Postgres adapter in Power BI is still not working. There are no issues when connecting via database management tools, like PGAdmin or DBeaver, or other BI tools, like Qlik Sense, to the AWS Postgres database without using 3rd party ODBC tools. I also don't understand why a PBI gateway is necessary while the AWS Postgres database is running in the cloud. So, I think @Microsoft is probably doing this for a competitive reason, since they also offering an Azure Postgres solution, which seems to be working without any issues.

       

      Regards Frank van Zuilen