Question about incremental refresh

[PowerBITestingG]

Does incremental refresh work if you add non foldable steps after filterin Start/EndRanges? 

Can you bypass that by loading the raw table with the filters and then using that as source in a new query?

I havent find the answer anywhere.

[amitchandak]

@PowerBITestingG , Not very clear, but you need make sure it foldable. For that make sure datatype is datetime  and filter it very first steps. If you add any non foldable steps and then you add filter then it will not fold.

Another way is have query and try to pass Power query variable

A example of in Fabric and Data flow

Incremental Data Load(ETL) for Warehouse using Dataflow Gen 2, SQL Procedure, Data Pipeline: https://www.youtube.com/watch?v=mpFRnZBXsvQ&list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39&index=1