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
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.

      • stribor45's avatar
        stribor45
        Post Prodigy
        2 years ago

        This is what i have done again

        1. Refresh in Desktop
        2. Refresh in Service which completed fine
        3. Looked at the report and seeing only April data
        4. Used external tool to conect to Dax Studio and see only one table with April data only