Incremental Refresh Initial Refresh

[jcarville]

Hi,

I'm using incremental refresh on a dataset that is calling an API directly. I would like to store rows for the last year, but only refresh rows for the last day.

However, I don't want to set the store rows option to 1 year initially as when I do the first refresh in the service it will hammer the API with too many calls. Is there a way to set the value I have highlighted below to be a small value e.g. 10 days for the initial refresh and then change this to be 1 year once the initial refresh has completed? I am using Premium and thinking it might be something that is possible through the XMLA endpoint?

Set this to 10 days for initial data load then change to 1 year

Any help is appreciated.

[GilbertQ]

Hi there

What you could possibly do is do this via the XMLA end point.

I think you might be able to copy and paste existing partitions using SSMS to achieve this.

[jcarville]

Thanks @GilbertQ, I appreciate your reply.

Do you know of any guides/blogs where someone has done this before?

[GilbertQ]

I was looking but for the life of me I cannot find it at the moment.

[jcarville]

No worries, appreciate you having a look.

I might use the method from this video as I have used it before and it will avoid that initial refresh issue but with a bit more work to get it set up: https://www.youtube.com/watch?v=T7ckdeGOhnU

[GilbertQ]

Cool, please let us know if that works?