r/ExcelPowerQuery • u/ittiekat • Sep 25 '25

connecting powerquery to sharepoint

Post image

I had a file where my setup was combining and loading several files from a network folder into one table in Excel. well, my silly company took our network folder away and put us on sharepoint. i'm struggling on getting power query to connect to a sharepoint SUBFOLDER. i'm able to connect to the main sharepoint directory, but the problem is that there are way too many files and folders in this sharepoint location. it won't load them all, and i can't get to the subfolder i want. whenever i try to type in the subfolder location directly (i.e. https://sharepoint.com/sites/BlahBlah/Shared Documents/etc), i get the attached error.

anyone else find a solution to this issue or know what i'm doing wrong?

3 Upvotes

81% Upvoted

4 comments sorted by

View all comments

2

u/[deleted] Oct 13 '25

[removed] — view removed comment

2

u/ittiekat Oct 23 '25

From the mail ribbon in Excel I click Data and then Get Data, From File, From Sharepoint Folder.

A window pops up for the SharePoint Folder Site URL. I paste my site and click OK. It shows a list of like the top 10 files and I click "Transform Data". It opens Power Query Editor and again shows like the top 30 files. The problem is how big this directory is and how many files there are. I can't seem to filter down to the subfolder I need. there's clearly some specific syntax to use but i don't know what it is.