Dropped number of months for incremental refresh, size of semantic model didn't change

[Don-Bot]

Can someone explain why when I dropped the number of months my Semantic Model stores for incremental refresh that the size of the model didn't change?  I used Tabular Editor to edit the number of months, dropped an entire year from it.  

[Anonymous]

Hi,@Don-Bot 

Regarding the issue you raised, my solution is as follows:

1.First, you can wait for a full refresh result: even if you reduce the number of months stored in the Tabular Editor, the actual data may not be deleted. An incremental refresh strategy may require a full refresh in the Power BI service to delete old data.

Here is a screenshot of the official document:

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...

2.Of course, you can also choose to republish according to your needs, but you need to be aware that republishing will delete both the partition and the data.

Here is a screenshot of the official document:

3.Second, you can check if your Query caching  causes the result.You can try turning query caching off and on first.
Here is a screenshot of the official document:

Query caching in Power BI Premium - Power BI | Microsoft Learn

4.Finally, model complexity: Even if some data is removed, the complexity of the model (such as calculated columns, measures, and so on) may still affect the model size.

Best Regards,

Leroy Lu

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