I'm still very new with Power BI and Power Query in general, and having some issues in trying to access files via SharePoint Online (we use office 365) I can enter the URL for our sharepoint site and sign on with my Org Credentials. But after I can't seem to filter or find most of the files on our SharePoint site that I do have rights and permissions too. When i access our sharepoint site via web browser, I can navigate between folders and see and open pretty much any file, etc. But in Power Query, I do not see pretty much any of those files. I'm not sure if I need to go back our our company's IT department yet to check permissions or not. I also have a mapped drive to our SharePoint files, and can also navigate and see them that way. And that did work by loading a file in power query that way. But I can't rely on the mapped drives alway's being there (drive letters change). Is there something I'm possibly missing in trying to locate certain folders/files via Sharepoint Folder? Thanks,PT

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.

Sharepoint Folder; Missing Folders/Files | Microsoft Fabric Community

Forum Discussion

Related content

Power BI file deleted from SharePoint folder

Sharepoint folder not synchronising new files

Merge data from multiple excel files from multiple sharepoint folders

How to connect my Sharepoint folder "My Files" folder through PBI Desktop using SharePoint Folder?

Excel files From Sharepoint folder to Lakehouse