Forum Discussion
PostgreSQL Invalid credentials
Hi magnetic_north,
Hope you are doing well.
For your query once double-check the Basic Authentication credentials, ensuring the password is correctly passed and matches the AWS RDS configuration.
We can follow these procedures to connect without using the gateway.
- If the PostgreSQL instance has a public IP and the security group allows access, connect directly over the internet.
- If not, set up a VPC Peering or VPN connection for secure access without a Gateway.
Hope these steps should resolve the "Invalid credentials" issue and establish a stable connection to your PostgreSQL database in AWS RDS.
your query was resolved! If our response addressed your question, please mark it as 'Accept Answer' and click 'Yes' if you found it helpful.
Thankyou for your understanding!
Regards,
Sahasra.
Hello magnetic_north ,
I sometimes face issues when connecting to postgresql, what I do is that I install and configure the odbc connector for postgresql then connect power bi through odbc.
you can check this https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Desktop-ODBC-Connectors-to-PostgreSQL-with-Direct-Query/td-p/1475352
Hi magnetic_north,
Thank you for reaching out to the Microsoft Fabric Community forum.
As Idrissshatila mentioned the response is accurate and will address your issue.
If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.
If the Super User's answer meets your requirements, please consider marking it as the Accepted solution to help the other members find it more easily.
Regards,
Sahasra.