Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Incremental Refresh

Hi.I want to create incremental refresh in my data flow. I have 3 data flow created in my pbi:

1. Dataflow 1-90 days

2. Dataflow 90-360 days

3. Dataflow opening balance

I want only my dataflow no.2 to be refresh with incremental. Should I put 91 days or 1 days in the "refresh rows in the last" selection?

 

Dataflow
Need Help

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago
    I would put the 91 days because you want it to only refresh after those 91 days?
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    It seems like you want to store the data in the last year and keep refreshing the data in the last 360-90+1=271 days...
    Please take a look at the offical document for reference.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

     

    Best Regards,
    Eyelyn Qin

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Sorry to disturb you...

    But did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

     

    Best Regards,
    Eyelyn Qin