PowerBI Connection Issue with Postgresql hosted on AWS

[IanLock]

Hello!

I'm currently having trouble accesing a postgreSQL instance that is hosted on AWS's relational database service (rds). I've properly setup the vpc, the corresponding route table, subnets, and internet gateway to whitelist my office's IP, but continously get errors when trying to connect.

After reading some of other posts on this forum, I've troubleshooted the following:
1. Reinstalled npgsql via their github releases (.msi file)
2. Downloaded the corresponding certs from AWS and added to trusted certificates
3. Disabled encryption which results in invalid credientials

Side note, I'm able to connect via odbc from my machine but I need to use the PostgreSQL connector in PowerBI as these reports will live in cloud on app.


Please provide guiance and support, thank you in advance!

[v-achippa]

Hi @IanLock,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Akash_Varuna for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @IanLock,

We wanted to kindly follow up to check if the solution provided by the user resolved your issue.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @IanLock,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Akash_Varuna · Accepted solution]

Hi @IanLock  Ensure the AWS RDS instance allows connections from your IP via security group rules. Check if SSL is required; use the correct AWS SSL certificate in Power BI settings. If ODBC works but not the connector, verify driver compatibility or try using DirectQuery.