Forum Discussion
incremental refresh do not store old data
Hi lbendlin
Im not familliar with the partition list and power query aspects as I'm new to power BI.
I updated my post to hold more data.
Can you please refer me to steps where I can see who to do what you told?
You should not ignore the warning about query folding. Since you are using a data source that may or may not support query folding there are many (MANY) things that can go wrong with incremental refresh. Since you mentioned Power Query - that is one thing. For example I have a CSV file based Incremental refresh running successfully against a Sharepoint folder (based on the Last modified Date of the CSV files) but ONLY after I ripped out nearly all of my M code and replaced it with equivalent code that somehow magically works with incremental refresh while my original code didn't. "Simple" things like the difference between Table.ExpandColumn and Table.Combine. Oh, yeah, and Microsoft support told me it cannot be done (I have the ticket to prove that they claimed that)
If you are just starting with Power BI then you should not work on incremental refresh, especially not with non-foldable data sources.