Forum Discussion
Some measures are breaking after 2nd incremental refresh
Super UserHere's what you need to remember about incremental refresh. Every time you make a structural/meta data change to your report (doesn't even have to be a change for the data source that you have defined the incremental refresh for) the Power BI service will do a full refresh, and will create all the partitions according to your "keep" specifications.
Only starting with the second refresh will it actually run an incremental refresh, touching only the partitions that you have specified in the "update" timeframe.
You need to provide more details about your incremental refresh setup (especially if you chose to enable data change checks), but maybe this explanation will already give you the reason why you see that behaviour.
Hi lbendlin,
I really appreciate you taking the time to help me. You're first response definitley cleared up a few things for me. I went ahead and tried deselecting the "enable data change checks", re-published and initiated incremental refresh - and got more or less the same results. I'm not exactly sure what you mean by "Every time you make a structural/meta data change to your report (doesn't even have to be a change for the data source that you have defined the incremental refresh for) the Power BI service will do a full refresh, and will create all the partitions according to your "keep" specifications." Could you clarify a bit more? The etfprices, rvol30 and impliedVol tables are updated daily and all have the same incremental refresh configuration as below. Below are screenshots of my incremental refresh configuration. Let me know if there is something off in there, where else I might be going wrong, or if there is anything else I could provide to make it easier for you to understand the issue.
Thanks so much once again for your help!!!
My parameters:
RangeStart ParameterRangeEnd Parameter
My custom filter on the etfprices table "date" column:
My incremental refresh configuration for the etfprices table: