Forum Discussion
Append Daily from one csv file to master table - Need Power Query
HI Members, I have one excel file in a folder which gets replaced everyday with that's day data . I need to append everyday to the master table i built in power bi. I used code like: =table.combi...
My question remains the same . How do i append data to master table from a daily report which keeps replacing its entire data set daily. Everyday it replaces previous day data and paste current day data. I need to add everyday data to master table
Hi Anonymous
If the "daily data" from your source file changes every day, then it would update to newest data in power bi and remove the yesterday's data.
You can create a folder which you add everyday data into, then import the folder into power bi.
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
After some transformation, you can append the daily data table with the master data table.
Best Regards
Maggie