Solved: ODBC connection for postgres

Anonymous · ‎01-19-2021

Using a connection string for ODBC connection , and connection getting fine but there is no option showing connection is

Direct Query or import but as per my knowledge it is like imported data set since power query option is also showing.

Please help me with this ?

mwegener · ‎01-19-2021

Hi @Anonymous

As I understand it, import mode is the default behavior. Only a few data sources support DirectQuery, that should also be a special case for ODBC.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

mwegener · ‎01-19-2021

Hi @Anonymous

As I understand it, import mode is the default behavior. Only a few data sources support DirectQuery, that should also be a special case for ODBC.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

ODBC connection for postgres