where can i see Direct Query option while connecting to power bi through ODBC

[psathanapal]

Hi Team,

where can i see Direct Query option while connecting to power bi through ODBC.

please see below screen, i dont see direct query enable option. so when i select any table, it is automatically considering as import storage mode.

below table is directly loded from a schema in SAP HANA DB.but it considering as import storage mode.

how can i set direct query mode option while connecting to power bi through ODBC?

Thanks,

Prashanth.

[v-shex-msft · Accepted solution]

Hi @psathanapal,

You can take a look at teh followibg docuemnt about enabed hte directequyer to odbc based on data conencotrs:

Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng