Aggregate Multiple Excels and Utilize Write-back

Hi,

for my experience best way to have refresh data is to use Sharepoint.

With sharepoint folder you can manage the data inside and select the file that you want take data and hour and delete the other from the import.

With sharepoint you have also the refresh scheduled in power bi service.

For your data the best way is to import all excel file into a sql azure database throught azure pipeline.

So you'll have a db with all your information.

To have the write back is not so easy but you need power app (another microsoft app) and you'll do the write on excel or better on sql. (find some video on youtube).

To use the power app for writeback sql i think you have to import data in direct query.

If you need a specific request tell me.

I hope I have been helpful.

Ciao!