Forum Discussion
PostgreSQL Invalid credentials
When attempting to connect to a PostGres database in AWS RDS, receiving Invalid credentials on setup. This occurs across multiple accounts, servers and databases. There is a gateway on the AWS to the internet. Power Automate can connect in the exact same manner, JDBC connections have no problem with this.
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.
7 Replies
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/1475352Hi 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.
Not really. It doesn't explain why the connector cannot handle Basic auth correctly, and using ODBC requires a Microsoft Gateway which this box doesn't have rather than just being natted to the internet. One thing of concern is that the upsertConnection2 request when creating the connection returns password as null. Hopefully that is simply a security step, and not actually passing a null password to the database for auth...
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.Hi magnetic_north,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.
