If Power Query new files and folders not showing in SharePoint, there can be something off with the permission, cache, or API ...
XDA Developers on MSN
I used to hate complex spreadsheet formulas and then I found Python in Excel
Excel is my database, Python is my brain.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results