Forum Discussion
New files in folder as data source
Hey everyone! I am using a folder in a centralized data server as a data source to process 3Rd parties report that comes in excel, always in the same format. After passing all the security check...
HI Anonymous ,
I'd like to suggest you get data from folder and do merge operation in query editor side. After these steps, your data table records will update if you add/remove files.
Notice: I also attached my test file below, you can take a look on it if it help for your scenario.
Regards,
Xiaoxin Sheng
Anonymous , thank you for your response!
Last time I processed the data using M to load the data contained in the files.
I tried "Combine and edit" and it works at least on the desktop version, I will try it out on PBI Service and let you know if I have any further issues.
Thank you for your help.
Best regards,
Diego.