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.
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.