Forum Discussion
Solved
Not able to setup Incremental Refresh .
Hello Everyone I have: Created RangeStart and RangeEnd parameters Filtered my fact table in Power Query using these parameters Verified that View Native Query is still enabled (query folding wor...
Hi Krishna_255,
Incremental Refresh only works when:
RangeStart and RangeEnd are Date/DateTime type
The filter is applied directly on the fact table’s date column
No transformations break query folding before the filter step
= Table.SelectRows(
Source,
each [OrderDate] >= RangeStart and [OrderDate] < RangeEnd
)- Apply the incremental filter as early as possible
- Avoid transformations before the filter
- Keep the column as DateTime, not Text
I'm glad you found a solution! We're here in the community to support each other.
Regards,
Rufyda Rahma | MIE