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

None of these links work. They highlight issues and show the ODBC solution, which doesn't support direct query) as well as one hosted on AWS. On the microsoft documentation it says postgresql itself (standard connector) can be done in direct query mode. Is this not possible in the service?