Make getting data from a folder containing Excel workbooks simple

I am an instructor who teaches students to use Power BI. There is often a need to import multiple Excel workbooks from a folder, but the fact that Power BI does not automatically or programmatically combine the Excel workbooks that have the same structure without throwing one error or another is quite shocking to me.

Currently, the only method that works is adding a column containing =Excel.CurrentWorbkook([Content]) and expanding/combining, but I would sure think Power BI could do that for the user without the user having to mess with all those steps.