Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Increment refresh not working as expected

Hi All   We have premium workspace and implemented an increment refresh on our dataset as follows :   Data archive 1 year  Increment refresh 90 days    Assume I have published the pbix file on...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks ,is their any way to drop the extra data and to show only last 1year data on subsequent refresh ..

 

If I do schedule refresh on 14th Jan 24 then my data should be from 15th Jan 23 to 14th Jan 24 only 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

Anonymous I believe that you would set the Archive to 365 days which should create an archive partition for each day and then 1 archive day partition will be dropped on each new refresh day. I *think*.