Forum Discussion

gellmann94's avatar
gellmann94
Frequent Visitor
6 years ago
Solved

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

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?

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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,

     

11 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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's avatar
      michaelshparber
      Advocate V
      6 years ago

      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's avatar
        v-lid-msft
        Community Support
        6 years ago

        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,

         

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,