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
amitchandak's avatar
amitchandak
Super User
4 years ago

HRM5 , I faced this issue in past and have no fixed resolution. I got rid sometime by doing some desc change in StartDate and enddate parameter.  If the setup is correct and it still does not work, I would like to check issues and log a new one if needed

https://community.powerbi.com/t5/Issues/idb-p/Issues

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.