Forum Discussion
Incremental Refresh with Power BI Pro License
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.
Cna you tell me more about this mehtod??
see my stutcaure is
3 categiorys of data it has backd ata okay
so till 2025 i kept in a seprrate folder for all 3 categiory like
f1bd
f2bd
And f3 bd
and from 2026 it anotehr folder as
f1cd
f2cd
and f3 cd
and my main wuesry has evrything appended all 6 folders okay...
and then like that main file is used for all the emasure and evryrthing...
so i dont want to touch or migrate thta otherwise my work gonna completeda to chanegs evrything....
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.