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
Hi cip - Your scenario suggests that you want to keep and import JSON data from previous days, but when you refresh your Power Query can only find the current JSON file. In this situation, I would recommend using Power Automate to extract the JSON each day and then load the JSON into SharePoint library. Power Query are then import all of the daily JSON files from the SharePoint library to combine them.