Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

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.