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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you. I have already looked at those sources and cannot find any reference to direct query. I am hesitant to switch to npgsql unless it will guarantee that I can then do direct query.

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
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