Forum Discussion
Incremental Refresh Error
Hi，
Thanks for the solutions davidding and rajendraongole1 provided, and i want to offer some more information for user to refet to.
hello rdini8 ,
the reason for the problem:
If you change the data type after you have set up incremental refresh, the current data type may be different from the data type in the historical interval during incremental refresh.
and the data may not be detected for this reason, so the data will not be returned.
Solution:
You may consider reconfiguring incremental refresh after changing the data type
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.
Hi, I have tried filtering both before and after datatype changes. It's not working for either.
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.
I haven't tried that. Should I disable and enable again?
