Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
garretes
New Member

This did not answer the question or show how to resolve, therefore resolution is not accepted.

Anonymous
Not applicable

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?

amitchandak
Super User
Super User

@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/

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.