Forum Discussion
Solved
Incremental Refresh with Power BI Pro License
Hi Community, I wanted to know how can I make my data to load for only last 1 day or 2 day in service? or in desktop my data like overall has data since last 6 year from 2020 to current... and data...
Hii Khushboobarai
Your current setup (multiple folders + append + main query) is the reason incremental refresh is not working. Incremental refresh only works when a single table has a proper Date column filtered using RangeStart/RangeEnd with query folding folder-based appends usually break this.
In your case, since you don’t want to change the main model, the best approach is:
- Create a separate staging query that directly reads only recent files (last 1–2 days) using a date filter
- Apply incremental refresh on that staging table
- Then append this small “recent data” into your existing model
This way, you avoid touching your main logic, reduce refresh time, and still get near-incremental behavior.
Hi Khushboobarai,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!