I can't synchronize Postgresql with Power BI Service

[ddellahi]

#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

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

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

[collinq]

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

[ddellahi]

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,