How to automate processing files for Power BI?

First a disclaimer because I'm totally noob with all the Azure stuff...   I'm getting finance transactions in Excel and csv format from several stakeholders. Currently I'm doing all this manually u...