Forum Discussion

jcarville's avatar
jcarville
Skilled Sharer
6 years ago

Incremental Refresh Initial Refresh

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.

Need Help

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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's avatar
      jcarville
      Skilled Sharer
      6 years ago

      Thanks GilbertQ, I appreciate your reply.

       

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

      • GilbertQ's avatar
        GilbertQ
        Super User
        6 years ago
        I was looking but for the life of me I cannot find it at the moment.