Forum Discussion

conniedevina's avatar
conniedevina
Helper I
4 years ago

Incremental Refresh date refresh

Hi All, I implemented Incremental Refresh for my report but I have a question regarding this incremental refresh. So let's say I implement the incremental refresh for Table A with below conditions....
Need Help
  • conniedevina's avatar
    conniedevina
    Helper I
    4 years ago

    Hi amitchandak ,

     

    Thanks for your reply! so I'm using sharepoint folder here and yes the date created is 22nd November 2021.

    I'm not sure why it's not included in my incremental refresh per today's date.

    Is RangeStart and RangeEnd will change automatically based on the today's date?

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      conniedevina , RangeStart, and RangeEnd what we create in power Query are for the initial Range?

      for incremental, this 7 days should work. can share settings for those two parameters

      • conniedevina's avatar
        conniedevina
        Helper I
        4 years ago

        Hi amitchandak ,

        so here is the parameter that I've created

         

        And here is the power query on my table that initiate the parameter

        = Table.SelectRows(#"Renamed Columns1", each [Date created] > RangeStart and [Date created] <= RangeEnd)

        Is it possible because the timezone problem? But I checked on some post they said the timezone based on scheduled refresh time that I've set, which is for me I am using Singapore time which same as the Date created