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.
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Join our monthly meetings and learning sessions.
We are excited to announce the Power BI Super Users!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.