Incremental Refresh Filter (RangeStart / RangeEnd) in Power Query M

Filters a table using the RangeStart and RangeEnd parameters required for Power BI incremental refresh.

Database & RefreshAdvancedincremental refreshrangestartrangeend

Power Query M code

let
    Source = YourTable,
    FilteredRows = Table.SelectRows(Source, each [DateColumn] >= RangeStart and [DateColumn] < RangeEnd)
in
    FilteredRows

Notes

RangeStart and RangeEnd must be defined as datetime parameters named exactly that, then configured under the table's Incremental Refresh settings.

Requirements

RangeStart and RangeEnd parameters defined in the Power BI Desktop file.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Incremental Refresh Filter (RangeStart / RangeEnd).