Forum Discussion

AhmedEssam's avatar
AhmedEssam
New Member
2 years ago

Connection postgresql with power bi Desktop

when try to connect power bi desk top with postgresql it give me error


Althoug i already successfully connected from my windows to the same postgresql database through Pgadmin.
How i can fix it ?

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi AhmedEssam ,

     

    Are you connecting to Azure PostgreSQL through a private endpoint? If you change to a public endpoint, is his connection working?

     

    Best Regards,

    Neeko Tang

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi AhmedEssam ,

         

        Let's troubleshoot and resolve this:

        1. First, ensure that you are connected to the internet and that your firewall is not blocking the connection. Try pinging the PostgreSQL server to confirm if you can access it. If you can't ping it, there might be network or firewall restrictions.

        2. Sometimes, SSL certificates can cause connection errors. Update the SSL certificate for your PostgreSQL server.
        Make sure the certificate is valid and matches the one used in your Pgadmin connection.

         

         

        For more details, please refer: Solved: PostgreSQL + powerbi desktop connection error - Microsoft Fabric Community

        How to Fix Power BI PostgreSQL Connection Error - Monocroft

         

        Best Regards,

        Neeko Tang

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