Which two parameters should you create to enable incremental refresh for a Power BI table in a typical scenario?

Which two parameters should you create to enable incremental refresh for a Power BI table in a typical scenario?

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

Answer: (D)

Incremental refresh in Power BI is controlled by two dynamic parameters that define the window of data to refresh. You create a date/time parameter named RangeStart and another named RangeEnd, and you use them in your source query to filter the data to that window. This allows Power BI to refresh only the new or changed data within RangeStart to RangeEnd, while older data can be kept without being reprocessed, improving performance on large datasets. In a typical setup you tie a date column (for example, OrderDate or CreatedDate) to these two parameters so the query filters between RangeStart and RangeEnd during each refresh. Other parameter names won’t be recognized by the built-in incremental refresh mechanism, so RangeStart and RangeEnd are the standard pair.

Incremental refresh in Power BI is controlled by two dynamic parameters that define the window of data to refresh. You create a date/time parameter named RangeStart and another named RangeEnd, and you use them in your source query to filter the data to that window. This allows Power BI to refresh only the new or changed data within RangeStart to RangeEnd, while older data can be kept without being reprocessed, improving performance on large datasets. In a typical setup you tie a date column (for example, OrderDate or CreatedDate) to these two parameters so the query filters between RangeStart and RangeEnd during each refresh. Other parameter names won’t be recognized by the built-in incremental refresh mechanism, so RangeStart and RangeEnd are the standard pair.