Forum Discussion
Incremental Refresh
From what I understand, you only need to set your parameters once. Upon refresh it will look at the period settings you entered when creating your Incremental Refresh.
I usually set my RangeEnd a year or two in advance (ie. 1/1/2023). I think I will need to adjust these at that time.
But at this point, there are articles and youtube videos that will probably provide a much more clearer explanation than I could. Two examples:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
https://www.sqlshack.com/an-overview-of-power-bi-incremental-refresh/
Hi DemandMGR
When you madde the parameters RangeStart & RangeEnd did you make them a DateTime datatype. Thats the only way it will work.
By the way what is your source, what type of files? Is it a source that supports incremental refresh?
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
Best regards,
Jeroen
I am not getting an error stating that "Unable to confirm if the M query can be folded. It is not recommended to use incremental refresh with non-foldable queries"
Do you happen to know what is causing this?