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?

------------------------------

{
"refresh": {
"type": "full",
"applyRefreshPolicy": true,
"objects": [
{
"database": XXX"
}
]
}
}

---------------------------------------------

 

Thanks,

Anand

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"
            }
          ]
    }

3 Replies

  • 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"
            }
          ]
    }
  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi AnandGNR 

     

    Do you mean to re-process all the partitions and tables?

    Or do you mean just a single partition?