Block update of a table with historical data

[Anonymous]

I am building a report with current data and old data. I don't need to update old data because it never changes.

there are more than 1 million lines needlessly updated every day.
Is there any way for me not to update a table with old data?

[Fowmy · Accepted solution]

@Anonymous 

Yes, you can control it using the incremental Refresh option, please refer to these:

https://www.youtube.com/watch?v=F9oYnq1omnA


https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#:~:text=With%20incremental%20refresh%2C%20the%20service,sensitive%20names%20RangeStart%20and%20RangeEnd.