Forum Discussion
Best Approach for Incremental Refresh When Historical Records Can Be Updated
I have a Power BI report that currently imports around 7 years of historical data. During each refresh, only about 1% of the records are actually updated, so I'm exploring whether incremental refresh...
Hey Mayankb024, sorry got pretty busy today
I would try to set the incremental refresh for the full 7 years (every time you refresh 7 years) with 1 day partition and Detect Data Changes active.
Like this you would not lose any modified data but you will refresh only small partitions?
I would give it a try and see if it works before going into the staging table which will require more effort.
Hi MattiaFratello So you are sayinh we will set archive data as one day and keep 7 years as incremental refresh with detect data changes. Let me try this approch. Thank you
Mayankb024 Let me now if it works. If not, I can try to think about the DB solution but maybe during the weekend.