Forum Discussion
Incremental refresh
Hi
Need some help pls - eg. I want to fetch data from website daily and add to the prvs data. Asking to add as parameter and not able to automate as index which will want as date.
Tried my luck in example I upload to make it practical
https://1drv.ms/u/s!ApFc0q97F5wrkBUExywEstiHvQvN?e=wlTHVG
Thnx in advance
Hi Anonymous ,
Unfortunately, incremental refresh is not support the date source not support query folding.
In your case, you can use M function to keep the increased part.
Use DateTime.LocalNow() and Date.IsInPreviousDay() to identify if the data is in you want date. If is then outcome True or something else. Then use filter to remove the False you do not want.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
Unfortunately, incremental refresh is not support the date source not support query folding.
In your case, you can use M function to keep the increased part.
Use DateTime.LocalNow() and Date.IsInPreviousDay() to identify if the data is in you want date. If is then outcome True or something else. Then use filter to remove the False you do not want.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.