My Database has one month of rolling data.Can I achieve to keep 3 months data in power bi by using incremental refresh ??
yes, that should be possible.
Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh https://blog.crossjoin.co.uk/category/incremental-refresh/
My data soruce having 1 month of roling data. I have implemented the incremental refresh to store 3 month data and refresh data for 15 days. But during refresh its store 1month of the data only. unable to understand is anything I am missing.
Hi @sumchak ,
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
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.
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.