Forum Discussion
Query on incremental refresh
Hi All, My Database has one month of rolling data.Can I achieve to keep 3 months data in power bi by using incremental refresh ?? Regards, Suman
Hi Anonymous ,
looks good to me. I would have now expected the amount of data to grow with every refresh in the Power BI Service.
But its not working as expected ..Can it be because the of the Soft delete or Hard delete in the source DB?
Hi Anonymous ,
the Detect data changes column should not be the same column used to partition the data.
Take a look at this video.
Power BI Incremental Refresh - Understanding Detect Data Changes
https://www.youtube.com/watch?v=JsJWBr1_ktQ
The implementation was correct but there are different sets of reasons why it wasn't working.
Thanks for your help.
Conclusion: Incremental refresh shouldn't be implemented if the data source doesn't support the foldable query feature.