Forum Discussion

Nepal101's avatar
Nepal101
Helper III
4 years ago

Partitions ( last processed Never)- ( incremental refresh)

I created an incremental refresh and used a partition to upload (13 months) of the data refresh happening for one day. Then I realized I need to add a new column to the dataset. Using the AML tool kit schema was created. But then when I refreshed it refreshed for a day as it is how incremental refresh policy is set up.  The data for the newly created column is blank so wondering if I need to reload all the partitions again?

Below is the picture, the last process is displayed Never not sure why that is? 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Nepal101 ,

     

    I have some questions.

    Are we talking about the incremental refresh in Power BI?

    How do you use the partition to create the incremental refresh? As far as I know the incremental refresh in Power BI is based on the RangeStart and RangeEnd parameters.

    How do you create the column with AML tool?

     

    Best Regards,

    Jay

    • Nepal101's avatar
      Nepal101
      Helper III
      4 years ago

      Due to the huge data, we cannot use an incremental refresh as it times out on us. The process of creating the policy for the incremental refresh is the same using the Range but then we can use the analysis service for partition. I just updated the changes using the AML tool kit but then I saw Never in the Last process not sure why and what I did that triggered.