Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

incremental refresh - not available, parameters not showing in custom date filter

Hi,   I'm trying out the new incremental refresh feature on a SSAS import datasource, but it's not available.   I Created the parameters RangeStart and RangeEnd, but when I try use them on the da...
Data Modeling
  • Anonymous's avatar
    Anonymous
    8 years ago

    I found the error. the datefield must be date/time, not just Date. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

this is how I have set it up

 

Added parameters

sajidmansoorali's avatar
sajidmansoorali
Icon for Helper I rankHelper I
8 years ago

after creating parameters you need to apply these parameter on any column of a sepecific table in query editor mode.

once done you will able to set incremental refresh on that specific table only. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I already added the custom date filter, using the parameters I have created to the Date columns in the table (field is called dato). (See the printscreen I've added earlier).

    • sajidmansoorali's avatar
      sajidmansoorali
      Icon for Helper I rankHelper I
      8 years ago

      are you creating incremental refresh on the same table which has been filtered through custom filter. i.e. SSAS Leveransepunkt. because incremental refresh will not work on any other table which has not been filtered through custom filter with parameters.

      • APattison's avatar
        APattison
        Frequent Visitor
        8 years ago

        I am having the same issue.

        Preview feature on, RangeStart and RangeEnd parameters defined on table, applied to Date/Time variable, but in the Incremental Refresh box for the same table shows the toggle as "off" with the warning showing that parameters need set up.