Forum Discussion

bill2999's avatar
bill2999
Regular Visitor
3 years ago

Setup Direct Query and PostgreSQL ODBC connection.

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 i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi bill2999 ,

 

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.

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.