Incremental - Parameters Not Working

[HRM5]

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 has been done.

Alreaded Added ParametersStill Says This Error

[amitchandak]

@HRM5 , Have you used them to filter the date column of the table? Only then it will work

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#filter-data

[HRM5]

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]

@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]

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]

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]

Ok @v-chenwuz-msft  Thanks

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