Unable to schedule refresh Postgres AWS RDS

[Anonymous]

Hi there,

I am trying to set up a Postgres connection to an AWS RDS. I've gone through the installation of NPGSQL on my local machine. I've managed to connect and import the data in Power BI desktop. However, when I go to refresh the data on Power BI web, I am unable to. I get the following error:

Failed to update data source credentials: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'

I'm able to refresh on Power BI desktop just fine and then publish. I just can't get it to refresh on the web service/set up the scheduled refreshing.

Does anyone have any ideas? I've tried rentering the credentials n the Dataflow page but still no luck.

Thanks. 

[Anonymous]

Hi @Anonymous,

Please review the solution in the following threads which has the similar problem with yours, hope they can resolve the problem.

Error while scheduling refresh to postgres database

An error happened while reading data from the provider

Connection of Power BI with RDS PostgreSQL on AWS from Scratch

Best Regards