Store data and append latest

Question

Hi,&nbsp;I have a dataflow which pulls the following data:&nbsp;&nbsp;Rem.&nbsp; House Purchase.&nbsp; &nbsp;Advance2%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2%&nbsp;The problem that I have is that it doesn'thave a date stamp so when I run it today and then tomorrow, I'll have 1 row of data but the values could change.&nbsp;&nbsp;What I want is to keep today's values and add a date it was updated and then tomorrow, the values append yesterday's so it would look something like this:&nbsp;Rem. House Purchase. Advance. Date2%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2%&nbsp; &nbsp; &nbsp; 15/05/243%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2%&nbsp; &nbsp; &nbsp; 16/05/24&nbsp;Is there anyway of doing this please?

lbendlin · Answer

Power BI has no memory. You need to manage your snapshots in the upstream system. Or consider moving to Fabric data lakes. Dataflow Gen2 have Append options.

m_sbs_6 · Answer

Thanks. Any idea how we could do this within a dataflow?&nbsp;

lbendlin · Answer

Not possible in a Gen1 dataflow. I don't have enough experience with Gen 2 dataflows but it might be possible there,

Forum Discussion

Store data and append latest

3 Replies

Related content

Dataflow - Append

Appending Data

How To Store Pipeline StartDate and Append into Lakehouse Table?

Stored Procedure to Manipulate Tables

How to load latest files from source and store adls gen2