Forum Discussion
How to not overwrite data in Power BI Dataflow
Hello! I am facing the following issue: I have 3 dataflows that are refreshed at diferent times due to a matter of resources. These 3 are linked and merged in a different dataflow that is use...
My question still stands. What prevents you from implementing incremental refresh against the original data source?
What prevents me is that, as data comes from a query to an API, the original data source is overwritten with new data on every load and in order to use an incremental refresh, "old" data needs to persist.
The data that I had yesterday, today is erased and changed with today's data.
You may be better off using event based reporting. Are your data changes tracked in your source system?