Forum Discussion
Helper IIs it possible to switch between incremental and full refresh of a dataflow?
Super User
There is another option in incremental reresh where you can enable it to detect data changes, which can be on a column which will update the date when data is being updated. This will then allow you to do is to be able to use incremental refresh as well as update for those columns where the data has changed Here are more details on this: Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Helper IHi! GilbertQ
The 'detect data changes' didn't worked for us because it doesn't detect changes at row level, e.g. if someones modify the content of one row that is in the 'historical' partition of the incremental refresh, then that modification won't be shown on the dashboard. That is the issue we are facing, we want to have incremental refresh for better perfomance but some historical records could be modified from time to time, that's why I was thinking if there is a way to automatically switch between full and incremental refresh?.
- GilbertQ
As far as I am away, we detect data changes does happen at the low level as long as you change the modified date on the row level. I have seen this working in the past.