Forum Discussion
Anonymous
4 years agoNot applicable
Direct Query and PostgreSQL
Hi I have connected to a PostgreSQL database using an ODBC connection. However I now want to connect a single table direct query. Is it possible to do this in any way? Many thanks in advance
- 4 years ago
Hi, Anonymous
You may have to use npgsql then use powerbi connector to achieve dq mode.
Reference:
Power Query PostgreSQL connector - Power Query | Microsoft Docs
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
ribisht17
4 years agoSuper User
Some useful links for you, >>Solved: Connecting to postgresql with direct query mode - Microsoft Power BI Community
1. https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
2. https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/
3. https://niftit.com/connecting-power-bi-to-postgresql/
Hope it helps!
Regards,
Ritesh