Partial Refresh

[PeopleAnalytics]

Hi,

We have a data table with lots of calculated columns for a long period of time.

The thing is when we add new rows to this table, it does the calculating for the columns from the start.

For example, our data is between 1st Jan 2019 and 1st March 2019. When we add the rows from 2nd of March, power bi calculates the columns again from 1st Jan and this takes a very very long time (around 5 hrs). 

What we need is a way for power bi to stop calculating like this and only calculate the new rows (after 2nd of March in this example).

Is there a way to do this?

Thank you,

[az38]

Hi @PeopleAnalytics 

Look here, but i haven't touc this option yet

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/