Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Error while scheduling refresh to postgres database

I tried scheduling a refresh to postgres database, while updating the credentials, got this error. Any idea how to resolve?   Failed to update data source credentials: An error happened while readi...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I figured out that the version of npgsl in the server and pc were different. There was no way for me to figure out what version was installed on the server. After a few trial and error attempts, I was able to fix it.

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

I would suggest you restart the gateway or re-install it to check if the issue persists. If it still persists,you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

  • To stop the service, run this command:

    ''' net stop PBIEgwService '''

  • To start the service, run this command:

    ''' net start PBIEgwService 

Here is the related case for your reference: https://community.powerbi.com/t5/Service/Repeated-refresh-failure/m-p/31913

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the help. Restarting and re-installing the gateway unfortunately did not help.

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

      Hi Anonymous ,

       

      You could create a support ticket here.