Incremental Refresh - data being removed from source

Hi, Danfountain 

If you want to change a semantic model that has been configured for incremental refresh, such as a full refresh of your semantic model, you will lose the data in the Archive data. You'll need to re-upload your PBIX file in Power BI Desktop. You can refer to the case link below:

Solved: How to clear or empty out a Power BI dataset that ... - Microsoft Fabric Community

Incremental refresh for Power BI refreshes are based on the policies that you set. In incremental refresh, when you set an incremental refresh policy, Power BI creates and manages partitions of your data. Only the most recent data that has changed needs to be refreshed. If you have successfully incrementally refreshed several times. If you suddenly have only nearly two months of data in your data source one day, the data in the Archive data compartment will still be able to use that data in Power BI, but it will be phased out according to the policies you set.

While incremental refresh is a powerful feature, it's important to understand its limitations and use it appropriately to ensure your data is preserved. If your data source only retains 2 months of data and needs to retain 12 months of data in your reports, you may also need to consider other strategies, such as archiving your data to a location where Power BI can access it. This will provide a more robust solution and ensure that no data is lost when changing the model.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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