Powerbi Service -> Postgres & DirectQuery

[kunde13]

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 ^?

[v-shex-msft · Accepted solution]

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

[kunde13]

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 🙂
Thanks!