Failed to update data source credentials for postgreSQL server in PowerBI Service

[gellmann94]

The full error message is :Failed to update data source credentials: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond'.

This happens in the PowerBI Service when I go to schedule a refresh for the data source.

The connection works fine in PowerBI Desktop, I can refresh the dataset without problems.

Is there any way to solve this issue?

[Nyamuha]

How to fix that problem help me!

[1123]

@michaelshparber

Hi, I have the same problem. Could you solve it?

[michaelshparber]

Hi @gellmann94 

Did you manage to make it work?

How?

Thanks

@v-lid-msft  I use personal GW, same error

Please help

Thanks

[v-lid-msft · Accepted solution]

Hi @gellmann94 ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @gellmann94 ,

Sorry for late reply, could you please check the valid status of credentials in dataset or under the gateway?

Have you tried to upgrade to the latest version if you are using the on-premises data gateway?

Best regards,

[michaelshparber]

Hi @v-lid-msft ,

When I Edit the credentials, I get this error message:

"Failed to update data source credentials: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"

I need to use personal GW, in enterprise it works OK

Please help

Thank you

Michael

[v-lid-msft]

Hi @michaelshparber ,

Since your credential can work in the Enterprise Gateway, we think the credential may be valid, the personal gateway mayhave the issue, could you please try to update the personal gateway to the latest version? Does the personal gateway run in the machine which have access to the source?

Best regards,

[michaelshparber]

@v-lid-msft 

Yes, the personal gateway is installed on the same machine as the enterprise GW.

The machine has access to postgreSQL data source.

I can successfully connect to it through enterprise GW but the personal GW doesn't allow me to enter the credentials.

The personal GW works fine when I connect to SQL Server but not postgreSQL...

I also tried to enter false credentials just to check - and the error is the same.

So I think something is stopping it before it even reaches the data source...

I tried to enter the name of the server including port and without port, the error is the same...

This is the error:

Failed to update data source credentials: An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

Please help!

Thank you!

[Anonymous]

I am facing the same issue, can you please help me if you were able to resolve it.

[pablosga]

Hi @michaelshparber , I have the same problem. Could you solve it?

Please help!

Thank you!

[Sudhakar510]

Please may I know, how did you managed to fix? My datasource is counting emails from outlook and its shared mailbox. It is working perfectly fine in Desktop and it worked before in service too but now it is not working in Service and I am getting data credential issues as below

Please help