Forum Discussion

ralwi65's avatar
ralwi65
Frequent Visitor
1 year ago
Solved

Postgres via PBI Service: No connection could be made because the target machine actively refused it

I wrote a report using DirectQuery Connection to a on-Premis PostgreSQL Database. Everything works fine except the connection via Power BI Service. The error message is  "No connection could be made ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ralwi65,

     

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


    Try these troubleshoot points:

     

    Temporarily disable antivirus/firewall on the PostgreSQL host and test.

    Try using IP address directly (if DNS might be masking something).

    Create a local test report using the gateway machine with a simple connection string and try using that in the gateway.

    Check for TLS/SSL enforcement mismatches between Gateway and PostgreSQL.

     


    If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.


    https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

     

    If this information was helpful, kindly mark the response as accepted and give it a thumbs-up so it can assist others as well.

     

    Best regards,
    Prasanna Kumar