Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incremental Refresh - Future values

Hi all,   I've setup incremental refresh for the main FACT table in our dataset. This table includes actuals and budget data.    THe incremental refresh is working correctly, however for the budg...
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    hi Anonymous 


    Here is the extract below

     

    And what you would need to do is to change the effectiveDate to be the date in the future you want it to go into.

    For example if you wanted it to go until the end of 2020 you would change it to the following:

     

    { 
      "refresh": {
        "type": "full",
    
        "applyRefreshPolicy": true,
        "effectiveDate": "12/31/2020",
    
        "objects": [
          {
            "database": "IR_AdventureWorks", 
            "table": "FactInternetSales" 
          }
        ]
      }
    }