Forum Discussion

AnandGNR's avatar
AnandGNR
Helper I
2 years ago
Solved

TMSL for implementing incremental refresh on a pbi dataset

Hi,   For datasets that are set up with incremental refresh: What would be the equivalent of starting a new manual refresh from the UI (in service) in TMSL:   Would it be this? ----------------...
Tutorial Requests
  • GilbertQ's avatar
    GilbertQ
    2 years ago

    Hi AnandGNR .

     

    Your syntax should be the following

     

    "refresh": {
          "type": "full",
          "applyRefreshPolicy": true,
          "effectiveDate": "10/27/2023",
          "objects": [
            {
              "database": "4d1fb213-aaa-0000-00aa-a670e2e9bbec"
            }
          ]
    }
AnandGNR's avatar
AnandGNR
Helper I
2 years ago

Hi GilbertQ ,

Its a dataset with an incremental refresh policy where we use the "LastModified" feature on it to detect all the partitions(monthly) that need reprocessing in the active zone(2 years) of the dataset. 

 

So when we do a manual refresh of such a configured dataset in PBI service, I am not sure what process mode it uses under the hood and hence the qn on how to do the same operation with TMSL...

 

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi AnandGNR .

     

    Your syntax should be the following

     

    "refresh": {
          "type": "full",
          "applyRefreshPolicy": true,
          "effectiveDate": "10/27/2023",
          "objects": [
            {
              "database": "4d1fb213-aaa-0000-00aa-a670e2e9bbec"
            }
          ]
    }