Can we pull in a table in direct query mode using Generic ODBC connector

[Ananda-Krishnan]

Hi Guys,

I'm new here and trying to explore Trino connectivity to Power BI.

I've used ODBC Generic connector for establishing the connectivity but I couldn't pull a table in 'Direct Query'. By default it is pulling in as Import query, is there any way to change it from Import to Direct query or to pull in a table as direct query itself.

Thanks in advance for any response.

[v-yajiewan-msft · Accepted solution]

Hi @Ananda-Krishnan,

As far as I know, the default ODBC data source does not support Direct Query:

Power Query ODBC connector - Power Query | Microsoft Learn

If you want to connect to ODBC via Direct Query, it’s necessary to create custom connectors for it with ODBC extensions.

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

Best regards,

Joyce

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