You have a Microsoft Power BI semantic model that contains a large fact table. You plan to enable incremental refresh. Which two parameters should you add to Power Query to enable incremental refresh?

You have a Microsoft Power BI semantic model that contains a large fact table. You plan to enable incremental refresh. Which two parameters should you add to Power Query to enable incremental refresh?

• A. FromDate and ToDate
• B. RangeStart and RangeEnd
• C. StartRange and EndRange
• D. DataRange and WindowSize

Answer: (B)

Incremental refresh hinges on two boundary parameters that define the current window of data to refresh. In Power Query, you create two parameters named RangeStart and RangeEnd (both typically Date/Time) and use them to filter the fact table by its date column. During a refresh, Power BI uses these parameters to pull only the rows within that window, while older data remains in a separate history partition. The two parameters must be named RangeStart and RangeEnd because that is what the incremental refresh engine expects; other names won’t integrate with the refresh policy. So the correct approach is to define RangeStart and RangeEnd in Power Query and apply a date filter using those parameters.

Incremental refresh hinges on two boundary parameters that define the current window of data to refresh. In Power Query, you create two parameters named RangeStart and RangeEnd (both typically Date/Time) and use them to filter the fact table by its date column. During a refresh, Power BI uses these parameters to pull only the rows within that window, while older data remains in a separate history partition. The two parameters must be named RangeStart and RangeEnd because that is what the incremental refresh engine expects; other names won’t integrate with the refresh policy. So the correct approach is to define RangeStart and RangeEnd in Power Query and apply a date filter using those parameters.