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/
I think it is more a Warning message rather than an error. I too get that message as well and I am using SQL tables. I don't think you will have an issue with Excel files.
I have tried studying foldable queries, but haven't been able to gain an understanding as yet.
Hope it all works out for you.
You are correct it was a warning. It let me turn it on. Wow! I can't believe I didnt see that.