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

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

 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Show your Power Query

    • stribor45's avatar
      stribor45
      Post Prodigy
      2 years ago

      you mean the code?

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Show how you applied the RangeStart and RangeEnd filters.