Can't connect to Azure PostgreSQL

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.