Forum Discussion
Incremental Refresh - only capture new data
I am working with a Reporting database that is refreshed 6 days a week (Sunday thru Friday at 10:00 pm) and skips holidays. This database is loaded from a functional database that is updated 7 days ...
Hi Anonymous
You could look at using the detect data changes in your data to look at which columns to refresh
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
I would suggest if the data does not change, just let the query run and re-import those rows. It should not create any issues?
Thanks for the suggestions.
I did not think 'Detect Data Changes' would help, because we don't want to apply any data changes, just add new rows.
And, unfortunately each row includes data that does not change, as well as data that can change. And the request is to have none of the data on the rows change.