Power Query - Get a List of File Names from Folders & Sub-folders

[wsnyder]

Hi all,

Using Office 365 ProPlus
Using Power Query in Excel to get a list of all files in a folder and all subfolders.
It's been running for at least 30 minutes - maybe longer.
Statusbar shows "Running background query..."
Cell A1 shows ExternalData_1:Getting Data....
I'm expecting 63,848 files and related metadata.
I'm going across Network on VPN
I can continue working in other workbooks - Excel is not frozen.

Do you think this will eventually return the expected results?
Have you seen long wait times like this?

Thanks
-w

 

[alansidman]

I tried to load all the files from Dropbox and it ran for about 3 minutes and then stopped. It indicated that it had run out of memory and had indicated that it has picked up about 1300 files. Let us know if it worked for you.