Possible to set up scheduled refresh based on premise?

[Anonymous]

Hi,

Is it possible to based on scheduled refresh 'tell' the report to show the values based on yesterdays update up until the scheduled refresh occurs on the current day?

[Anonymous]

Thanks perfect!

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

Did you mean only show the last valus?

You can use incremental refresh . Set sort in the last list as 1 day. Then the dataset will keep only the last one day value.

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.

[lbendlin]

no need to tell anyone - that is exactly how it works. If a refresh fails then the previous version will continue to be available.