Forum Discussion
Is anyone successfully using Incremental Refresh?
I was excited to see that the PBI Service supports incremental refresh. So I dug into it. Got everything configured according to the documentation. Worked great - refresh times plummeted. B...
Hi ctmullins ,
incremental refresh works very well for me.
A common mistake I encountered several times is confusion about >= RangeStart and < RangeEnd. The equal sign must occur exactly once in the filter statement, otherwise data becomes inconsistent.
Another pitfall is using incremental refresh on dimension tables. Although it is possible, it's usually very tricky to get the logic right. Therefore I'd absolutely recommend to only use incremental refresh on fact tables.
Whenever I avoided these two pitfalls, incremental refresh worked extremely well.