Forum Discussion

M-M-P's avatar
M-M-P
Icon for Helper III rankHelper III
1 year ago
Solved

After data refresh, spikes are seen in the data.

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. ev...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Is incremental refresh involved?

M-M-P's avatar
M-M-P
Icon for Helper III rankHelper III
1 year ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    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's avatar
      M-M-P
      Icon for Helper III rankHelper III
      1 year ago

      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.

    • M-M-P's avatar
      M-M-P
      Icon for Helper III rankHelper III
      1 year ago

      lbendlin 
      It worked, thank you very much.

    • M-M-P's avatar
      M-M-P
      Icon for Helper III rankHelper III
      1 year ago

      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's avatar
        lbendlin
        Icon for Super User rankSuper User
        1 year ago

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