Forum Discussion
Postgres via PBI Service: No connection could be made because the target machine actively refused it
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-ticketIf 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
Super UserHi ralwi65
Based off the error message above, it appears that the target machine you're going to, which is your postgres database, is not accepting the call. What I recommend you can try to do is use the command prompt to telnet on the dns name and port to the postgre server and see if that can access it successfully. How to telnet to an IP address on a specific port? - Super User
SaiTejaTalasila