Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

DirectQuery with ODBC (Postgre SQL)

#1. I first created a connection against PostgreSQL and it works fine in desktop but issues on Power BI services. #2. I then create ODBC against PostgreSQL (imported) and thats working well in Po...

Anonymous
4 years ago
Hi Anonymous,

I'd like to suggest you take a look at the following document to create a custom connector with 'direct query' enabled on odbc driver if helps:

Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Docs

Regards,

Xiaoxin Sheng

Icon for Super User rank

Super User

4 years ago

Anonymous , You have to use PostgreSQL connector for that. In Case it not a cloud offering. Make sure you are using on-premise gateway

Gateway
https://radacad.com/the-power-bi-gateway-all-you-need-to-know
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot

Also check if needed

postgresql
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/
https://niftit.com/connecting-power-bi-to-postgresql/

Related content