Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

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
v-shex-msft
Community Support
Community Support

Syndicated - Outbound

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
garretes
New Member

Syndicated - Outbound

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

v-shex-msft
Community Support
Community Support

Syndicated - Outbound

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Syndicated - Outbound

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
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)