Excel Power Query | Mac | Get excel from folders AND sub folders

HI All,

Has anyone managed to get power query on mac working to load excel files from folders & sub folders? 

By following this for the main folder  https://www.mrexcel.com/excel-tips/power-query-debuts-for-excel-for-mac-but-with-significant-gaps/

I'm halfway there but have hit a prob on the files that are stored in sub folders.

It brings them back but doesn't ref them correctly (path is that of the parent folder) and so data load fails..

Thanks in advance

Dave