Forum Discussion
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 Power BI services = Schedule report
#3. But I would like to have DirectQuery against PostgreSQL (Power BI Services) but it seams that ODBC will not give me that option but I wonder if its possible?
Regards Mikael
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
4 Replies
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-tshootAlso 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/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
The website talks a lot about the theory but how do you actually make a custom connector with 'direct query' enabled?
This did not answer the question or show how to resolve, therefore resolution is not accepted.
