Forum Discussion
Incremental Refresh Questions
1. datetime or dateinteger
2. convert/cast to datetime
3. don't use that unless absolutely necessary
4. store 5 years, refresh 24 months
5. no. If you specify months then the smallest partition will be month
6. only if you sit on your hands. Older partitions will be recreated when you make meta data changes and republish the pbix, and you can also manually update those partitions.
hi,
re #3 ... presume it will only refresh the partitions it needs to within the 24 mths ... is that correct ? We have lots of data in our 24mth window and would not want whole 24mth to get pulled in every time.
Thanks
if you specify 24 months then it will refresh all 24 partitions. If you don't want that, specify a smaller window and refresh the older partitions on a manual basis (every quarter for example). If you really must, read about the "Detect Data Changes" process again, identify a suitable column, and try it out. (Not endorsing that, but your situation might require it)