Incremental refresh until tomorrow

[Cado_one]

Hi,

I use incremental refresh to refresh only the last few days of electrical market values.

My problem is that the last value is the one of the next day (1 day in the future) and incremental refresh refreshes only the values until the current day.

I saw this topic from 2018 Incremental Refreshes - how to accomplish future d... - Microsoft Power BI Community and the given solution is said to be reserved for premium capacity owners. Is it still the case ?

And if it is, do you know any workaround to manage incremental refresh until tomorrow's date ?

I thought adding a column with a one day shift in the past compared to the query's date column, but maybe someone has a better idea ?

Best regards

Cado

[Cado_one · Accepted solution]

Problem solved :

I added a column with a one day shift in the past compared to the timestamp of the data.

This way incremental refresh based on this one day late colum refresh until the date of today which corresponds to the date of tomorrow for the date column used in the query.

Have a good day

Cado

[Greg_Deckler]

@Cado_one Incremental refresh used to be a Premium-only feature but is now available for Pro as well.

[Cado_one]

Hi @Greg_Deckler 

I know incremental refresh is available because I use it. My question concerns the possibility to incrementally refresh a table until a date in the future.