Forum Discussion
AWS RDS Postgres refresh from PowerBI service - the remote certificate is invalid
Hi andyclap
As far as I can see you would need to install a Gateway Server so that you could get the right certificate installed.
I have found putting the Gateway servers in a cluster allows for there to not be a single point of failure.
I would put the Gateway Server in AWS using an EC2 instance so that it is as close as possible to the RDS source.
Yeah, looks like exactly the same issue as mine.
If it's a fully managed database as a service, there's not a lot you can do - microsoft don't want to make it convenient to use competing clouds, you need a gateway.
If it is your own database on DO infrastructure, then I'd guess you should be able to bring your own certificates -- I've no experience of Digital Ocean though.
As mentioned, we gave in and moved to Azure managed postgres - turns out to have been a good decision, it's qute a solid service and good value for our use-case.
Indeed. We used a gateway at the end as well icw an ODBC connection which doesn't seem to have any certificate issues.