Forum Discussion

HRM5's avatar
HRM5
Frequent Visitor
4 years ago

Incremental - Parameters Not Working

Hi, 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...
Need Help
Show and Tell
Tips and Tricks
HRM5's avatar
HRM5
Frequent Visitor
4 years ago

Hi amitchandak 

I have done everything, actually the data is 2.2 million rows and it takes lot of time to refresh and after applying Parameters

RangeStart (MM/DD/YYYY)

RangeEnd (MM/DD/YYYY)

and InvoiceDate (MM/DD/YYYY)
I then applied custom filter to the invoice Date and when I go to configure the Incremental Refresh it says No Parameters Defined..!!!

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi HRM5 ,

 

RangeStart and RangeEnd should be Date/Time , "mm/dd/yyyy hh:nn:ss AMPM"

 

Please refer this link.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • HRM5's avatar
    HRM5
    Frequent Visitor
    4 years ago

    Ok v-chenwuz-msft  Thanks

    I have applied that before and the parameter problem is fixed.