Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Direct Query and PostgreSQL

Hi   I have connected to a PostgreSQL database using an ODBC connection. However I now want to connect a single table direct query. Is it possible to do this in any way?   Many thanks in advance
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Anonymous 

     

    You may have to use npgsql then use powerbi connector to achieve dq mode.

    Reference:

    Power Query PostgreSQL connector - Power Query | Microsoft Docs

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

brandon061017's avatar
brandon061017
Frequent Visitor
4 years ago

Same question here! Documentation says supports Direct Query/Live, but can't find any way to do it. Everyone says to do it in the service, you have to use ODBC which doesn't support direct query. Any assistance greatly appreciated. Thanks!