Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost 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
Icon for Super User rankSuper User
2 years ago

partitions are filled on the second refresh.

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost 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
    Icon for Super User rankSuper 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
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      How do i go back on track now?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper 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.