Forum Discussion
how to make connection from Power BI Desktop with AWS RDS Postgre SQL
Hello everyone,
I am trying to connect PBI Desktop with AWS RDS PostgreSQL (XXXXXXXXXXXX us-east-1-rds.amazonaws.com) we have enabled port 5435 for communication and still, it throwing an error as 'unable to connect'. Alternatively, I have used the ODBC connector we are able to connect but additionally, we need to set up a gateway, internet connectivity for the Prod server and need other assistance from the network team. Here, we are looking for a direct connection from PBI Desktop with AWS RDS Postgre SQL. Any assistance would be greatly appreciated.
Thank you.
2 Replies
- rajendraongole1
Super User
Hi 50134591 - check your network and security configurations, Use a PostgreSQL client like pgAdmin or a simple command-line tool like psql to test connectivity from your machine.
check the following links for more inform
Controlling access with security groups - Amazon Relational Database Service
PostgreSQL: Documentation: 16: 21.1. The pg_hba.conf File
Power Query PostgreSQL connector - Power Query | Microsoft Learn
Hope the above information helps.
Hi 50134591 ,
Have you solved your problem? You may want to check the following two configurations:
SSL Configuration: Ensure that SSL is configured correctly.AWS RDS requires that connections be made using SSL. You need to download the AWS public key and convert it to a certificate using an SSL converter. Import this certificate into a trusted root certificate authority on your machine.Install Npgsql: Ensure that Npgsql, which allows PostgreSQL to be accessed by . You can install it using the Package Manager console in Visual Studio.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
