Forum Discussion
Incremental Refresh for Fabric Warehouse Views
Community SupportWe are following up once again regarding your query. Could you please confirm if you have raised ideas with Microsoft?If not please raise idea and upvote it. Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.
Hi,
Yep I did reach out to Microsoft Support and they couldn't figure it out.
I did however figure it out but I'm not 100% how. I removed a single calculated column which used a couple of switch statements from the table in question and also removed the date filtering on the view itself (both of which had previously worked when incrementally refreshing the view in our SQL DW) and it began to work so I'm not sure whether it was one of those things causing the issue or a combination of the two but I've got it working.
- v-prasare
Hi jackstrudleywsh,
Thanks for sharing this, great to hear you got it working
It sounds like either the calculated column (with SWITCH logic), the date filtering in the view, or both were likely breaking query folding, causing the full refresh behavior.
This is a useful finding, as it shows that complex transformations and pre-filtering in views can interfere with incremental refresh in Fabric Warehouse.
Even if the exact cause isn’t fully clear, simplifying transformations and handling filtering in Power BI seems to help. Would be great if you can share any further observations
Thanks,
Prashanth