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

I have enabled the incremental feature in preview features as mentioned.

 

I get the incremental refresh option when I right-click on the table, but it is off, and I can't enable it in the dialogbox. It says that I have to add paramaters to the dataset filter, but this has been done.

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.