cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NoodleCat
Frequent Visitor

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 and not years. The filter on the incremental refresh table was set to > RangeStart and <= RangeEnd. When we needed to reload some historical monthly partitions the first day of each month was missing. BECAUSE THE FILTER LOGIC ON THE INCREMENTAL IS INVOKED. We changed our filter to be >= RangeStart and <= RangeEnd and voila! first day of the calendar month exists.

 

we have incremental refresh and aggregate tables working well - if you're struggling, @ me and maybe I had the same trouble 🙂

3 REPLIES 3
GilbertQ
Super User II
Super User II

Happy to help!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User II
Super User II

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

THANK YOU for the note about the first of the month.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates