Establish a connection to Postgresql on AWS RDS

[prihana]

The article at this link didnt solve the issue.

I want to connect to a RDS Postgresql instance. I have the db hostname, username and password alonf with the certificate to log into the server.

How to make a connection to this database?

[themistoklis]

@prihana

You actually have 2 options:

1. Connect directly to PostgreSQL 

2. Through ODBC connection

On this option you need to create the connection first on ODBC Data SourceAdministrator. Check if the client is 32 or 64bit

[VFXPro]

Does any of the suggestions above allow refreshes via Power BI service?

[v-danhe-msft]

Hi @prihana,

Based on my research, could you have tried to refer to below link to Configuring Power BI Connectivity to PostgreSQL Database:

https://community.powerbi.com/t5/Community-Blog/Configuring-Power-BI-Connectivity-to-PostgreSQL-Data...

Regards,

Daniel He