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.
Hii Khushboobarai
Incremental refresh in Power BI Pro works only in the background using RangeStart and RangeEnd, and these parameters are not visible or selectable in Service (by design). To load only the last 1–2 days, you must apply a date filter in Power Query using these parameters and enable incremental refresh (e.g., store 6 years, refresh last 1–2 days). If your refresh still takes 40–60 minutes, it usually means query folding is not happening or a full refresh is being triggered instead of incremental.
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.
