PostgreSQL Invalid credentials

[magnetic_north]

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. 

[magnetic_north]

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...

[v-sgandrathi · Accepted solution]

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.

[v-sgandrathi]

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.

[v-sgandrathi]

Hi @magnetic_north,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thanks for using Microsoft Fabric Community Forum.

[v-sgandrathi]

Hi @magnetic_north,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and select "Yes" if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[Idrissshatila]

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-wit...

[v-sgandrathi]

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.