Forum Discussion
Appending data without replacing data
Yes, Power BI is not the right tool for storing data. You could use a Power Automate process like this or any other process you choose to store the data, then point Power BI at wherever you saved that daily data.
See these prior threads too:
https://community.powerbi.com/t5/Desktop/How-to-append-data-over-time/m-p/1789673https://community.powerbi.com/t5/Desktop/Make-time-series-of-daily-data/td-p/1769767
https://community.powerbi.com/t5/Power-Query/Update-CSV-Excel-instead-of-overwrite/m-p/2307705
Sorry for the radio silence, I have been AFK for the past two days.
I will try my luck with PowerAutomate then and for sure will bear that in mind next time I come across similar situations when I need to store data.
Thank you so much for the swift response and help, really appreciate it! 🙏