Forum Discussion
Incremental load with pre filter data
I want to import data from table, but I want to apply filter before importing the data to Power BI. Is it possible with Import option? Once I imported the data. I want to schedule incremntal refresh ...
Might be an option. Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn
For Hive ODBC, install the Cloudera driver, setup your connection in the ODBC manager, and consume it. Nothing special, really.
You are describing the concept of "Query Folding", pushing computation upstream. It is generally a desired (but not mandatory) part of the incremental refresh setup.