I am importing various folders with different Excel files in them with Power Query.
I am using the following command:
SharePoint.Contents(url as text, optional options as nullable record) as table
as described in: https://learn.microsoft.com/en-us/powerquery-m/sharepoint-contents