Forum Discussion

andyclap's avatar
andyclap
Advocate IV
5 years ago
Solved

AWS RDS Postgres refresh from PowerBI service - the remote certificate is invalid

Hi - I have been trying to refresh a PowerBI report based on postgres DB datasource hosted on AWS RDS directly in the PowerBi service, not via a gateway.   The report works locally (after installin...
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    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.

GilbertQ's avatar
GilbertQ
Super User
5 years ago

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.

andyclap's avatar
andyclap
Advocate IV
5 years ago

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 🙂