Power BI Desktop freezing when I try to connect to a PostgresSQL database

[jimbender1976]

Hi All,

I am new to Power BI Desktop -- When I try to connect to a Postgres SQL database in the program, I do these steps:

1. Click "Get Data form another source"

2. I choose "PostgresSQL database" as the connection type

3. It prompts me to enter the Server and Database

4. I enter these, and click "OK" <-- But at this point, the application freezes.  It does not proceed forward from here. 

Does anyone know what I might have to do to get through this issue?

[amitchandak]

@jimbender1976 , Make sure correct driver is installed.

do not miss any step

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

[jimbender1976]

Ok Thank You!! : ) We will try this!