Along with RangeEnd, a reserved Date/Time parameter in Power Query (the names are case-sensitive). Filtering a table's date column with the pair lets Power BI apply incremental refresh and build partitions by date.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains RangeStart in context, with comparison tables and the common traps.
Terms in this definition
- State
A parameter in OAuth that carries custom data through the authorisation flow and back, as with the "Support state parameter" option in APIM.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Power BI
Microsoft's analytics and reporting service. It reaches data held on-premises through the on-premises data gateway.
- APPLY
Evaluates a table-valued expression for every row on its left, inside
FROM. Think ofOUTER APPLYas a left outer join andCROSS APPLYas an inner join. - Incremental refresh
Rather than reloading everything, a table is split into date-based partitions and only new or changed periods are reloaded. Semantic models rely on RangeStart and RangeEnd parameters here; Dataflow Gen2 uses buckets instead, and needs a fixed-schema destination.