Forum Discussion
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 works)
However, when I try to configure Incremental Refresh in the model, Power BI throws an error saying parameters are not detected.
What am I missing?
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
3 Replies
your filter isn’t in the exact pattern Power BI detects. In Power Query, the date filter must be directly on the date/datetime column and look like:
[Date] >= RangeStart and [Date] < RangeEnd
If you used Date.From(), DateTime.From(), Text, Int, try…otherwise, or filtered on a calculated column, Power BI often won’t detect it even if folding still shows.
Second: the column type must match the parameters.
If your fact column is DateTime, then RangeStart/RangeEnd must be DateTime too (not Date), and vice-versa.Quick fix checklist:
Make sure the fact column is Date/DateTime
Reapply the filter exactly as:
>= RangeStart
< RangeEnd
Ensure RangeStart/RangeEnd are the same type as the column
Apply incremental refresh on an Import table only
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 TextI'm glad you found a solution! We're here in the community to support each other.
Regards,
Rufyda Rahma | MIE
