Forum Discussion
trend data capture question
Hi signalpirate ,
I saw you mention "get their data from dataflows", so I want to ask that whether you are using Dataflow Gen 1 or Dataflow Gen 2?
If you are using Dataflow Gen 2, when you set the destination of your dataflow, you can set the dataflow's update methods to Append instead of Replace:In this way, your previous data will be saved in your Destination, and your subsequent updated data will be appended and saved below the existing data (as long as the data structure and data type of the two are the same). This way you can get complete data, not just data updated today.
Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
would something like creating a power automate work to export the data?
i can't figure out whats the best query to use to run against the dataset to "save all" basically.
the dataflow i have has multiple tables so i think i'd need to do this per table.
Again, not too great at this so any help would be appreciated.
Hi signalpirate ,
I saw you mention "get their data from dataflows", so I want to ask that whether you are using Dataflow Gen 1 or Dataflow Gen 2?
If you are using Dataflow Gen 2, when you set the destination of your dataflow, you can set the dataflow's update methods to Append instead of Replace:
In this way, your previous data will be saved in your Destination, and your subsequent updated data will be appended and saved below the existing data (as long as the data structure and data type of the two are the same). This way you can get complete data, not just data updated today.
Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.