Forum Discussion
Issue with Incremental Refresh in Dataflows - Data from Previous Days Getting Deleted
Hello everyone, I have set up two dataflows to create an 8-day data history. The first dataflow (dataflow1) stores data from the past 24 hours and refreshes at 10:30:00 PM, 12:00:00 AM, and 6:00:00 ...
I believe the problem lies with the fact that Dataflow2 references a table in Dataflow1 that stores data for only 24 hours for the incremental refresh process. You may want to look at this article for more explanation and the solution - https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create (Creating a dataflow by using Linked tables session). Please let me know if this sheds a bit of light on the solution.