Not able to setup Incremental Refresh .

[Krishna_255]

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?

[Rufyda]

I'm glad you found a solution! We're here in the community to support each other.

Regards,
Rufyda Rahma | MIE 

[cengizhanarslan]

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:

1. Make sure the fact column is Date/DateTime

2. Reapply the filter exactly as:

   • >= RangeStart

   • < RangeEnd

3. Ensure RangeStart/RangeEnd are the same type as the column

4. Apply incremental refresh on an Import table only

[Abhilash_P · Accepted solution]

Hi @Krishna_255,

Incremental Refresh only works when:

1. RangeStart and RangeEnd are Date/DateTime type

2. The filter is applied directly on the fact table’s date column

3. 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