Error while scheduling refresh to postgres database

[gowtham_raj_n]

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

[gowtham_raj_n · Accepted solution]

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]

Hi @gowtham_raj_n ,

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

[gowtham_raj_n]

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

[v-eachen-msft]

Hi @gowtham_raj_n ,

You could create a support ticket here.