Forum Discussion
I can't synchronize Postgresql with Power BI Service
Hi ddellahi ,
According to your error message, by my research, there may be the following reasons:
- Firewall or Proxy. Try to disable your firewall or proxy and try again.
- The server is not running. Hence it wont listen to that port. If it's a service you may want to restart the service.
- The server is running but that port is blocked by Windows Firewall or other firewall. You can enable the program to go through firewall in the Inbound list.
- There is a security program on your PC, i.e a Internet Security or Antivirus that blocks several ports on your PC.
- If it happens occasionally and retrying succeeds, it is likely because the server has a full 'backlog'.
Hope it helps!
Please refer to the docs: No connection could be made because the target machine actively refused it-Stack Overflow
No connection could be made because the target machine actively refused it
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHI ddellahi ,
Since the message says that the target machine actively refused it then that indicates to me that this is a firewall or permissions issue on the Postgresql machine.
Here is the Microsoft document:
Power Query PostgreSQL connector - Power Query | Microsoft Docs
There is a link here with some suggestions as well:
Configuring Power BI Connectivity to PostgreSQL Database - oxcrx34285
Hello collinq,
Thank you for your response,
I read what it was inside these two links, but it doesn't help me like already wrote I don't have a problem with Power BI Destock, which means that I can connect and synchronize my databases with Power bi destock, and those topics solve the problem of Power Bi destock that I don't have.
Thank you again,