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.
