After data refresh, spikes are seen in the data.

[M-M-P]

I have a problem for which I cannot find a solution.
When I publish to Power BI Service everything looks fine, see figure 1.
So after an auto refresh at night, data spikes are now seen at 1 a.m. every day, where there is now a double value, see figure 2. This only happens for the current month.

If I retrieve the data from the graph, there are no duplicate values.
The totaled values ​​I have in a card do not include the spikes in the total either.

I've tried turning off incremental refresh, to no avail.
I have tried using a different date picker with no luck.
I have gone through the DAX code but can't find anything there, it is very simple.

Data is retrieved via SQL.

I've been working with Power BI for a few years now and have never seen power bi show wrong like that before.

Your input is very welcome.

Figure1:

Figure 2:

[lbendlin]

Is incremental refresh involved?

[M-M-P]

@lbendlin 
Yes, we use incremental refresh in order not to load our servers more than necessary.

[lbendlin · Accepted solution]

You made a mistake in the definition of the RangeEnd filter.

Between RangeStart and RangeEnd only one of them can be inclusive (usually RangeStart). The other one must be exclusive

RangeStart <= Date

Date < RangeEnd

[M-M-P]

@lbendlin 
A follow up question if you have time?

Incremental refresh is set to 3 days, but the error spikes were in the current month. So now it is 18 days with spikes.

Any idea why it didn't just do the spikes for the past 3 days?

Does it look further forward than I set it to?

[lbendlin]

Partition boundary rules affect all partitions.  Whenever you make meta data changes and republish that will result in all partitions being destroyed and rebuilt.

[M-M-P]

@lbendlin 
It worked, thank you very much.

[M-M-P]

@lbendlin 

Thanks, yes I had "Date <= RangeEnd".
I have posted a new version and we will see.

Strange that this hasn't been a problem before.