Forum Discussion

yesoriginal's avatar
yesoriginal
Regular Visitor
1 year ago
Solved

Incremental refresh corrupting data

I have a large table with data (more than 20 GB). So I set up incremental refresh. Everything works fine, but for the last 3 months the data for the first day of the month for some reason doubles.
Maybe someone has encountered this?
In the desktop version, if you remove the filter from Power Query by date - everything is displayed fine.

 

  • Incremental refresh requires

    • >= RangeStart
    • < RangeEnd

    Please check if this is misconfigured.

     

    If not have a look at the source system

  • Yes, that helped. Thank you very much.
    I had
    >= RangeStart
    <= RangeEnd

3 Replies

  • Deku's avatar
    Deku
    Super User

    Incremental refresh requires

    • >= RangeStart
    • < RangeEnd

    Please check if this is misconfigured.

     

    If not have a look at the source system

    • yesoriginal's avatar
      yesoriginal
      Regular Visitor

      Yes, that helped. Thank you very much.
      I had
      >= RangeStart
      <= RangeEnd

      • Deku's avatar
        Deku
        Super User

        Been there, done that