Power BI Incr dataset

[PBILover]

Hi,

how does the power BI incremental refresh handle changes in the underlying data source, such as updates or deletions of previous loaded data on a historical range?

Thanks

[v-zhengdxu-msft]

Hi @PBILover 

Just as @pallavi_r  said that the incremental refresh does not work on historical range,.

If you want to update or delete previous loaded data on a historical range, please close the incremental refresh by close this button:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PBILover]

Thanks @v-zhengdxu-msft , is there any thing we can do by using the custom query for the detect data changes option mentined in the MS document?

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...

[pallavi_r]

Hi, Incremental refresh does not work on historical range. We need to do full dataset refresh for any update or deletion on the historical data.