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.
Hi everyone,
I’m running into the same issue mentioned earlier with connecting Power BI Service directly to a cloud-hosted PostgreSQL database — but in my case, the database is hosted on DigitalOcean.
Power BI Desktop connects fine after I install the root certificates, but in the Power BI Service, I get:
Details: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.' Please have this information handy if you choose to create a support ticket.
Seems like the service doesn’t trust DigitalOcean’s root certs. I’d prefer not to use a data gateway for architectural and maintenance reasons.
Has anyone found a workaround or solution for this with non-Azure cloud databases like DigitalOcean?
Any help is appreciated!
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.
