Incremental Refresh

[bhelou]

Hello Community ,

thank you as usual for the help ,

I have a problem in incremental refresh , I have set the parameteres the start & end date e and fileterd the column date in query and is working perfetclty but when going to the tables and applying the incremental refresh is stays off wont turn on ,

* Power BI Desktop is version # 2.79

* Data is from Oracle Database

*Dates are in the same format

Thank you for your usual help .

Attached images

[v-alq-msft · Accepted solution]

Hi, @bhelou 

For incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. If you use names like 'start', 'end', the same error happens as below. Please modify them as 'RangeStart' and 'RangeEnd'.

For further information, please refer the official document .

Best Regards

Allan

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

[Greg_Deckler]

See response here: https://community.powerbi.com/t5/Desktop/Incremental-Refresh/m-p/1064155