pbPassingBI
/
power bi/interview questions/what-is-incremental-refresh-

What is incremental refresh and when do you need it?

intermediate
Service & governance
Answer

Incremental refresh partitions a large table by date so only recent partitions are reloaded, rather than the whole table.

It is configured in Power BI Desktop using two reserved parameters, RangeStart and RangeEnd, which Power Query uses to filter the table. The Service then manages partitioning.

You need it once refresh windows get long — it dramatically cuts refresh time and source load on large fact tables.

Related
How do you implement row-level security?What is the difference between USERNAME() and USERPRINCIPALNAME()?What are the workspace roles and what can each do?