Forum Discussion
Direct Query with ODBC
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 ...
- 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?
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.