In the attached cell A1 is a named range FPath. Adjust it to your path, refresh the table below. Empty folders included.
Instead of using a named range, the path could be hard-coded into the query.
Stolen from
Power Query How to list folder names only NOT files | Page 2 | MrExcel Message Board