This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
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
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
Can we use an M function to automatically set the ranges??
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 15 | |
| 11 | |
| 9 | |
| 8 | |
| 6 |
| User | Count |
|---|---|
| 27 | |
| 23 | |
| 17 | |
| 13 | |
| 13 |