cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kunde13 Frequent Visitor
Frequent Visitor

Powerbi Service -> Postgres & DirectQuery

Hi!

 

DirectQuery is not working on PowerBi Service. But it does work on PowerBI desktop.

 

Is this on the roadmap or already scheduled to release as this feature is available in PowerBi Desktop.

When can one configure a PowerBi Gateway to use DirectQuery with Postgres?

There is an open source connector https://github.com/sgoley/DirectQuery-for-ODBC-in-PowerBI for this, but I've yet to test it.

Anyone tested that ^?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Powerbi Service -> Postgres & DirectQuery

Hi @kunde13 ,

>>DirectQuery is not working on PowerBi Service. But it does work on PowerBI desktop.
In my opinion, I'd like to suggest you take a look at following links about create a custom connector to enable direct query connection mode.(it include detailed steps and sample formula)

Enabling direct query for a data source via an odbc driver

DataConnectors/m-extensions#next-steps

BTW, please don't forget to enable custom connector support on your gateway.

Use custom data connectors with the on-premises data gateway

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
2 REPLIES 2
Community Support Team
Community Support Team

Re: Powerbi Service -> Postgres & DirectQuery

Hi @kunde13 ,

>>DirectQuery is not working on PowerBi Service. But it does work on PowerBI desktop.
In my opinion, I'd like to suggest you take a look at following links about create a custom connector to enable direct query connection mode.(it include detailed steps and sample formula)

Enabling direct query for a data source via an odbc driver

DataConnectors/m-extensions#next-steps

BTW, please don't forget to enable custom connector support on your gateway.

Use custom data connectors with the on-premises data gateway

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
kunde13 Frequent Visitor
Frequent Visitor

Re: Powerbi Service -> Postgres & DirectQuery

Hey,

 

thanks for the input.

Today an update for the gateway was released which includes support for DirectQuery on the gateway.

So my problem is gone Smiley Happy
Thanks!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 114 members 1,610 guests
Please welcome our newest community members: