Forum Discussion

rdini8's avatar
rdini8
Helper I
2 years ago

Incremental Refresh Error

Hi everyone, Incremental refresh stops working when I changed the data type of another column.     These are my applied steps. I made no changes to the datetime column used for filtering. I ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rdini8 

Thanks for your quick reply, you may not understand what I mean, are you already setting incremental refresh, and then back to Power Query to add the step of modifying the data type, because you have set up incremental refresh, so the original type is retained in the historical partition, when you modify the data type, after the partition is refreshed, you can't find the new data type in the original data, so you need to set the incremental refresh again.

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rdini8's avatar
rdini8
Helper I
2 years ago

I haven't tried that. Should I disable and enable again?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi rdini8 

    Yes, you can try it, reset the incremental refresh, then try to refresh it agian.

     

    Best Regards!

    Yolo Zhu

     

    • rdini8's avatar
      rdini8
      Helper I
      2 years ago

      Thanks will try it. I was adding data and refreshing the dataset in the service continously. Is there a time duration before I should refresh or can i refresh everytime I add data?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi rdini8 

        If you just add data and the data type does not change, you do not need to refresh it every time.

         

        Best Regards!

        Yolo Zhu