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,
what if you create very small partitions, like 1 day, and you refresh the full period (7 years), but activate the Detect Data Changes? In this way if Power BI detects a change in a row, it will refresh only 1 day and not a full month.
I'm a bit unsure about how it will handle so many partitions but you could give it a try?
Other option is to get a staging table in your source data with only the latest version of a record but maybe you would need helo of your DEs?