Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 days ago

incremental refresh

the semantic model size is around 3 GB ( in pbix) and takes lot of time to download, currently all tables are in import mode . i am planning to implement incremental refresh however the data from sou...
Need Help
power bi
krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
2 days ago

Hi powerbiexpert22​ 

Incremental refresh does not detect deletes. Rows deleted from source will be in model partition and Detect data changes only catches the deletes

You can add IsDeleted and LastModified columns at source. Filter out deleted rows in Power Query with IsDeleted = 'false' and enable Detect data changes on LastModified so partition refreshes when row is flagged as deleted. Increase refresh window to see how far back deletes can happen as older partitions are not reloaded

Once published with incremental refresh then .pbix can not be downloaded back from service so keep a development copy and use Tabular Editor for model changes

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

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