Forum Discussion

Krishna_255's avatar
Krishna_255
New Member
7 months ago
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...
Need Help
Tips and Tricks
  • Abhilash_P's avatar
    Abhilash_P
    7 months ago

    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

Abhilash_P's avatar
Abhilash_P
Super User
7 months ago

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