Forum Discussion

dmoskowitz's avatar
dmoskowitz
Icon for Helper I rankHelper I
4 years ago

How do I append a refreshed file to previous data without losing original data?

I have a source file that gets refreshed every month with new data.  Below is my current flow. It opens a file and then it separately opens the folder containg the file to capture the file details. I...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

dmoskowitz you can have files in the same folder and read all files from the folder, yes you can have one historical file assuming it has a date column in it to separate the data by period and as new files come in, it will read the folder and append the files together.

 

There are tons of blog posts that you can search that will get you thru the solution. If you are not able to figure it out, let me know.

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

dmoskowitz's avatar
dmoskowitz
Icon for Helper I rankHelper I
4 years ago

Thanks. So right now, I have the source file alone in a folder. Reason being is that my second query, Query1, creates a table using the "From Folder" option as it is the only way I could figure out how to extract the file date. If there are other files, it forces me to append them.

 

I'll keep on checking for other methods before asking you for more help 🙂

 

Thanks!