Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 @sumchak,
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.
Yes , I am fetching data from log analytics where we have only one month of data.
Hi @sumchak ,
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 @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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |