Incremental Refresh

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[GilbertQ]

I would put the 91 days because you want it to only refresh after those 91 days?