Forum Discussion
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 has been done.
Alreaded Added ParametersStill Says This Error
6 Replies
- amitchandakSuper User
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
- HRM5Frequent Visitor
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! ?- amitchandakSuper User
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