If Power Query new files and folders not showing in SharePoint, there can be something off with the permission, cache, or API ...
How-To Geek on MSN
How to use column from examples in Excel Power Query
Unlike one-off tools, Column From Examples records transformation steps so results remain stable as new data is added.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results