Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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