Questions about incremental refresh behavior

Hi Lullabit13,

Thank you for reaching out in Microsoft Community Forum.

Thank you GilbertQ for the helpful response.

1. Historical records do not update automatically, If a record moves to a historical partition and its date changes later, Power BI will not detect it unless you manually refresh historical partitions (via XMLA in Premium).

2. Deleted records within the refresh window are removed automatically, as Power BI drops and reloads those partitions. However, records outside the refresh window remain in Power BI, since historical partitions are never refreshed automatically.

3. 'Detect Data Changes' does not track deletions. It only refreshes partitions where changes are detected, meaning deleted records may remain in Power BI unless the entire partition is refreshed.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.