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.
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.
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.