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.

Pilares's avatar
Pilares
Helper I
3 years ago

Is there already a working solution available? I've tried above proposed solution, including using a qualified aws domain and physical ip address. The standard Postgres adapter in Power BI is still not working. There are no issues when connecting via database management tools, like PGAdmin or DBeaver, or other BI tools, like Qlik Sense.

 

Regards Frank van Zuilen

andyclap's avatar
andyclap
Advocate IV
3 years ago

Unfortunately not.

 

The Aws root certificates are not trusted for some reason (anticompetitive?)

 

You can put something inbetween, either your own PBI gateway or some other form of proxy, but this adds complexity.

 

As mentioned we went for postgres on Azure, and it's working ok for us.