Incremental refresh

[Anonymous]

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

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

Unfortunately, incremental refresh is not support the date source not support query folding.

Supported-data-sources 

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.