Question

You are configuring incremental refresh on an Import-mode fact table in a Fabric semantic model. The table has 200 million rows spanning eight years, but only the most recent two years of data ever changes. You add the required parameters and define an incremental refresh policy in Power BI Desktop. The first Power Query step must filter the source query so the service can partition the data correctly. Which requirement must you satisfy for the incremental refresh policy to work?

Accepted Answer

Create two parameters named RangeStart and RangeEnd of type Date/Time and use them in a filter step on the date column

Answer

Create a single parameter named RefreshWindow of type Whole Number that specifies how many years to keep

Answer

Add a calculated column in DAX that flags rows modified in the last two years, then filter the visual on that flag

Answer

Enable large semantic model storage format so the service can automatically detect changed partitions