Forum Discussion
Data outside the range parameter of incremental refresh changes
I pull my data with Odata feed, after i create parameters for the incremental refresh, Then i refresh the table -> Its seem that data outside the range changes also, is that mean the Incremental refresh does not work?
The 'View native query' is disabled but when i check the 'Diagnose step' i saw Http request that shows that query folding is working..
Is that mean that the incremental refresh does not work or its someting else that i didnt understand?
10 Replies
Hey Anonymous ,
when you set up an incremental refresh, you define a time window that should be refreshed and a time frame that should be kept. For example, keep the data of the last 5 years and refresh the last 2 weeks.
For every refresh only the last 2 weeks will be refreshed. If you have changes 3 weeks ago, they will not appear in your data set as they are out of the refresh window. In this case you have to expand the window or define that changes after a certain amount will not be considered.
The refresh window is a rolling window by the way. So every day the window moves by one day. In 2 weeks the data until today will be refreshed. But I guess that was clear.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicThanks selimovd, I will explane myself again:
Even if i put:
Store 5 years
refresh 2 weeks
data that older then the last 2 weeks will also update...
Infact, all of our Data is updated....Hey Anonymous ,
sorry, thought that was a question about the time window 😉
Can you check in your query if the steps where you filter by date are still in query folding? Can you make sure that the column you filter has the date format and that the parameters are called RangeStart and RangeEnd?
See the details about incremental refresh here:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Anonymous for IR to work, the source should support query folding. Here is a blog post that talks about where query folding is not possible and but still how you can use IR.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
