Forum Discussion
XMLA endpoints and incremental refesh
fun thing we just learned and thought I'd share we have incremental refresh set up with 10 day refresh and 60 month retention. I chose 60 months and not 5 years so the partitions would be months a...
Thanks for sharing
Just note that there could potentially be an overal with the <= RangeEnd because when the code is used in the PBI Service the RangeEnd is always the first day of the next month. THis is so that it does not have to factor in the end days of each and every month
With your logic it would then overlap the first day of the month twice, because the <= RangeEnd would be <= 20210501 for the Monday of Apr 2021, and when you then do it for the Month of May the RangeStart would be 20210501 and the Range End would be 20210601
THANK YOU for the note about the first of the month.