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 reading data from the provider: 'Could not load file or assembly 'netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51

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.

4 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.