Forum Discussion
Solved
Get data from folder and append
Hi, I am testing get data from folder and append. I was told that some automation can be performed here. The goal is to append new file from excel every month to an exising file. I do get data f...
Hi gtamir,
Just need to make sure all worksheets you want to combine share the same structure, then, place the new generated Excel file into the same folder, refresh the existing query PSSales in Power BI desktop, the new data will be appended automatically.
Best regards,
Yuliana Gu
I've done the same test and it is working fine without any issues.... Two files in the folder as below..
Created a simple table viz. and the output is as belo...
Now added another file in the source folder
Now refresh the data for the table
The table viz. will automatically reflect the new data...
gtamir That’s Cool :smileyhappy: