Build first, understand later.
If Power Query new files and folders not showing in SharePoint, there can be something off with the permission, cache, or API ...