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

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

      Show your Power Query

      • stribor45's avatar
        stribor45
        Icon for Post Prodigy rankPost Prodigy
        2 years ago

        you mean the code?