Forum Discussion

Khushboobarai's avatar
Khushboobarai
Helper IV
5 months ago
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...
Need Help
  • rohit1991's avatar
    rohit1991
    5 months ago

    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.

       
v-sgandrathi's avatar
v-sgandrathi
Community Support
4 months ago

Hi Khushboobarai,

 

Thank you rohit1991 for your prompt response to the query.

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help.

 

Thank you.