Semantic Model Refresh Fails with Memory Limit Error on F2 (Rolling 12-Month Full Load)

Hi drgenius 

1.Is storage the issue 

No, this is not a storage problem. 6 MB before execution means model is dropped & rebuilt during the refresh. Failure happens due to peak memory during processing and not the storage limits

2.Can Incremental Refresh still work if any month can change?

Yes, you don’t need full refresh where you can configure Incremental Refresh with rolling 12 months. For older corrections you can use Detect data changes based on modified date column

Even if any month can change, it doesn’t mean all months change every day

Failing is because full refresh = all partitions processed together. F2 limit = 3 GB per operation for a single semantic model of import mode. If the process hits ~3.5 GB  then it fails immediately

Please go through these documentation for your reference.

Incremental refresh overview -https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Incremental refresh configuration - https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

Incremental refresh troubleshoot - https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot

Large semantic models - https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-premium-large-models