Forum Discussion
FabiNeed
3 years agoHelper I
Historize data from dataflow
Hi all, I have a dataflow which gets data via an API on a daily basis. Naturally, the dataflow always contains the most up to date information. However, for my use case, I would like to show the ...
- 3 years ago
That is odd that you can't get past data. In that case, I would use Power Automate to call the API every day and write the data to a csv (with the date in the filename). You can then use incremental refresh to combine those csv files (not required, but it will speed it up significantly once you get a lot of them).
Pat
ppm1
3 years agoSolution Sage
That is odd that you can't get past data. In that case, I would use Power Automate to call the API every day and write the data to a csv (with the date in the filename). You can then use incremental refresh to combine those csv files (not required, but it will speed it up significantly once you get a lot of them).
Pat