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.
We are excited to announce the Power BI Super Users!
Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.