Forum Discussion
Connecting to postgresql with direct query mode
Hello,
I used the odbc connector to connect postgresql before and I want to use direct query mode now, it seems that odbc do not support this mode.
When I changed to use standard postgres connector, this error came out, dont know how to solve it.
I installed npgsql4.0.10 with GAC installation.
phchu1226 , Please check these solutions in past, please do not miss any step
ttps://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/
https://niftit.com/connecting-power-bi-to-postgresql/
2 Replies
phchu1226 , Please check these solutions in past, please do not miss any step
ttps://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/
https://niftit.com/connecting-power-bi-to-postgresql/Dear amitchandak ,
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
This link helps, I unselect the “Encrypt connections” option, it is able to connect via powerbi desktop.
