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 did not realize it only worked for Date/Time, I have it set for Date because all the sales files are in Date format. So if I change it to Date/TIme I would also have to change all the source files Date column to Date/Time as well for it to work?
The source files are excel files. Someone enters the sales data from the previous day in the most recent excel sales file and then I am refreshing to add the new data. What I am hoping his will do is only refresh the file that is being updated daily.