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.
Thanks for quick reply...
what the best method to convert our datetimezone col to dattime?
what would the reason be not to use detect changes ?
how does the partition refresh work if detect change isnt used
so if we have a window of 24 mths .. any changes within the 24 mths will get picked up.. is that correct?
thanks
1. DateTime.From()
2. it doubles the dataset size
3. refresh will be done based on the refresh rules you specified (ie the top 24 partitions)
4. yes