Setup Direct Query and PostgreSQL ODBC connection.

Question

In PowerBI I have setup an ODBC connection to a Greenplum Postgres database. While this connection is successful "importing" the data into the report, I do not get the "Direct Query" option -which is what I want. I have read it is possible to set "Direct Query" using something called M (but this may be Powerquery? is this in PowerBI?) and ODBC at the link below.

Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn

Does anyone know if it is possible to setup DirectQuery with Postgres using an ODBC driver?

anonymous · Answer

Hi&nbsp;bill2999&nbsp;,
&nbsp;
You can connect to PostgreSQL based on the built-in connector. It provides the DrectQuery mode to choose.

You can also try switching the import to DirectQuery in Model view.

&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

bill2999 · Answer

Thanks for the response, unfortunately when I connect through an ODBC driver neither of those options are available (There is no data connectivity mode through ODBC and the two storage modes other than import are grayed out.&nbsp; &nbsp;I tried using the advanced editor and setting "SupportsDirectQuery=true" but no luck.&nbsp;&nbsp;

Forum Discussion

Setup Direct Query and PostgreSQL ODBC connection.

2 Replies

Related content

Dataflow connection to PostgreSQL

Direct Query and PostgreSQL

Configure Gateway to connect to PostgreSQL

Dataflow Connect to AWS Postgresql

Connecting to Data: PostgreSQL (Function) error