Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 refr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks 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....

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

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:

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#supported-data-sources

 

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 regards
Denis