Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago

Incremental Refresh

I am trying to test incremental refresh and in my power query i have data from January 1 2024 until today.  I also  have set up  parameters (RangeStart and RangeEnd) to be between April 1 - April 9. ...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
2 years ago

partitions are filled on the second refresh.

stribor45's avatar
stribor45
Post Prodigy
2 years ago

lbendlin do i do that from the desktop in my model? i tried that and it didnt work for me

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    no, if you do that in the desktop it will reset back.  You have to refresh in the service to distribute the data across the defined partitions.

    • stribor45's avatar
      stribor45
      Post Prodigy
      2 years ago

      How do i go back on track now?

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Have you done a service refresh after your last publish?  has it completed?  Use SSMS or DAX Studio to confirm that you indeed have more than one partition, and that they are filled with rows and have different timestamps.