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
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/1789673
https://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