incremental refresh question

[srk_powerbi]

when i set up incremental refresh on the table , i choose to store last 3 years of data, however after refresh completes i see the earliest date in the table is 01/01/2019,  Does it only consider ' full year'  because it supposed to store from 04/01/2018 since  the latest date in table is 04/01/2021.  i did not the check the option 'only refresh complete periods' .

Please suggest

[Icey]

Hi @srk_powerbi ,

What's the value of "RangeStart" parameter? Maybe the issue is caused by this.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.