Is anyone successfully using Incremental Refresh?

Hi ctmullins ,

Based on the testing, incremental refreshes will not mess up the data. Incremental refresh extends scheduled refresh operations by providing automated partition creation and management for semantic model tables that frequently load new and updated data.

The filter on the date column is used to dynamically partition the data into period ranges in the Power BI service. Incremental refresh isn't designed to support cases where the filtered date column is updated in the source system. An update is interpreted as an insertion and a deletion, not an actual update.

You can also view the following document to learn more information.

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.