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 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.
Accepting this as the answer - while it's not the answer I would like, it is correct for the current PowerBI service offering.
We're finding Postgres in Azure quite good 🙂
Oh, I was under the impression PostgreSQL could be refreshed from the service without a gateway.
Based on this document it is not necessary to install a gateway in order to connect to to PostgreSQL (column Gateway (required) shows No).
I would love to be able to afford a cluster of windows servers, but we're not a huge enterprise and so to create and maintain our own "pet" servers just to mediate a cloud service connecting to another cloud service isn't a path we really want to go down.
Is there a SaaS offering in Azure for gateway servers that we could just configure and let Azure look after?
