Adding daily data to historical table

[gheisargheisar]

Hi all,

Does anyone have an idea of making a historical table? I have daily data that I want to add to the existing data table every day. I want to append the new file with the existing file without overwriting. Adding rows to the existing table.

Thanks

Gheisar

[v-juanli-msft · Accepted solution]

Hi @gheisargheisar 

It should be possible in some case.

1. Assume your data is local, you have different files for historical data and current data.

In this case,

• Name the files with dates information.
• Make the historical data file and current data file in the same folder, then connect to the folder with Power BI.
• Create a copy the original query in Edit queries, one query to show the last file(current data), another to show historical data.

References:

https://community.powerbi.com/t5/Desktop/Historical-data-when-changing-data-sources-every-month/td-p...

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

2. If your data is online and changes everytime, please refer to the thread which is much helpful.

https://community.powerbi.com/t5/Desktop/store-historical-data-from-Power-BI-Online/m-p/128189#M5444...

https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-us...

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.