Can't connect to Azure PostgreSQL

[asocorrocognex]

I get "invalid credentials" when trying to create a connection in the gateway, and also if I try to connect directly from a dataflow in the Service.

I can connect fine from the gateway server itself.

[Poojara_D12]

Hi @asocorrocognex 

The "invalid credentials" error likely occurs due to mismatched credential types, incorrect input format, or insufficient permissions. Ensure the credentials are accurate, match the expected authentication type, and the user has access rights. Also, verify the gateway is configured correctly, updated, and can reach the data source without network restrictions.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[Anonymous]

Hi, @asocorrocognex 

I've noticed that some users try to use the ODBC connector instead of the PostgreSQL connector, but note that you'll need to reconfigure the data source and may need to modify the query. You can check the following links:

Solved: Configure Gateway to connect to PostgreSQL - Microsoft Fabric Community

Solved: PostgreSQL connection through On-premise Data Gate... - Page 2 - Microsoft Fabric Community

If you need to use a gateway to connect to PostgreSQL, it's also a good idea to use ODBC.
Using ODBC is also a suggestion to try. You can check the following link:

PowerBI and PostgreSQL : SSL, Let’s encrypt and Gateway

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[asocorrocognex]

Hi Ankit, I can log in to the PostgreSQL database using pgAdmin from the gateway server.

[AnkitKukreja]

Hi! @asocorrocognex 

Please check if the ports are open for outside connection to the gateway server? Also check for firewalls that might be blocking the connection.