Sharepoint Folder; Missing Folders/Files

Which connector did you use, Sharepoint Folder or Sharepoint List ?

By the way there is another connector that you can try - SharePoint.Contents - PowerQuery M | Microsoft Docs  - it gives raw access to all content.

Also set the API level 14 if you still have issues (15 is sometimes iffy)

ptmuldoon The default SharePoint.Files connection only lists the first 5,000 files, so it might not find everything. In the Source line for the SharePoint connection change SharePoint.Files to SharePoint.Contents (it is case sensitive) in the formula bar (make sure that is visible in the View tab of Power Query - check the "Formula Bar" button) then drill down the folder structure. The first place you probably need to go is to Share Documents, then you will start to see files and folders that make sense.

I generally prefer SharePoint.Contents as it is faster, but it does have one drawback. When you are combining files, you can only combine files in one folder vs SharePoint.Files which will combine whatever files you filter down to. But SharePoint.Contents doesn't have the file listing limitation .Files does.

Thanks guy.  Both of you pointed me in the right direction and with SharePoint.Contents was able to drill down and locate the file(s).

I'm sure I'll be back with some more questions though 🙂