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

    Yes amitchandak 

    Absolutely, I have applied the custom filter onto that DateTime column and then I was able to see the Native Query as well but when I set up incremental on Table outside the Power Query it gives me error of no Parameters..

    Any Help! ?

    • 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..!!!