Incremental refresh - Process ADD

[Alexander24]

Hi there

Can anyone advise how we would achieve the same output as process add in Power BI's Incremental Refresh.

In Tabular, you can set a partition to only add new rows, so not even updating historic rows, i.e adding new rows added to the table in the last 5-10mins.

Thanks

Alexander

[v-shex-msft]

Hi @Alexander24,

In fact, incremental refresh feature not works as you thought, it need to manually setting parameters as refresh range.

Please take a look at following link to know more about this feature.

Incremental refresh in Power BI Premium

Regards,

Xiaoxin Sheng

[Alexander24]

Can we use an M function to automatically set the ranges??

[v-shex-msft]

HI @Alexander24,

According to official document, it seems like incremental feature not support auto config. You need to manually setting these range before use it.
In addition, you can also submit an idea to idea forum to help us improve this feature.

Regards,

Xiaoxin Sheng