Forum Discussion
I can't synchronize Postgresql with Power BI Service
#Urgent
Failed to update data source credentials: An error happened while reading data from the provider: 'No connection could be made because the target machine actively refused it'Hide details
| Activity ID: | 84ecd691-9063-4be0-b19d-3ada470fc89a |
| Request ID: | 599628d1-4906-8f83-98d9-e1f204176a2a |
| Status code: | 400 |
| Time: | Fri Jun 17 2022 18:10:13 GMT+0100 (GMT+01:00) |
| Service version: | 13.0.18489.36 |
| Client version: | 2206.2.11758-train |
| Cluster URI: | https://wabi-north-europe-redirect.analysis.windows.net/ |
NB : There's no problem with Power BI Destock or other apps
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.
3 Replies
HI 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,
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.
