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?
Hi DemandMGR
Sorry, Excel files are unstructured data and do not support query folding. They also do not support Automatic Incremental Refresh with the parameters. Datasource that use SQL and Odata do.
So the only solution is to manually create a incremental logic bij unchecking the "include in refresh" option for query's that do not need to be refreshed.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