Direct Query with ODBC

[Anonymous]

Hi,

Is there any way to get Direct Query mode by using ODBC as it's not there - I know, But any workaround to get Direct Query for ODBC.

I have seen few microsoft documents to enable the Direct Query for ODBC - but not much more clear on that.

Appreciate your help/suggestions.

[foodd]

• Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn
• Using builtin Odbc.DataSource - PowerQuery M | Microsoft Learn 

However, your tradeoff is that this breaks query folding.   What is your specific need, and what alternatives have you identified for your source?

[Anonymous]

Hi @foodd ,

I need to filter the data- by dates (need to bind the date  - parameterization), and to bind the column you need direct query - though in ODBC it won't allow hence I need some work around.