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.

andyclap's avatar
andyclap
Advocate IV
5 years ago

Anyway, we have moved to Azure postgres, which does allow BI connections without a gateway.

 

The whole gateway architecture is a concern for me: while it's completely understandable for access to on-prem data sources, it doesn't feel the right architecture for a BI cloud service.

I'd need an "on-demand" gateway managed cloud service in Azure that is pay by usage (or naturally preferably free for PowerBI Pro) before considering it.