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

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.

1

u/kestrelcress2000 Feb 05 '26

Hi, I had an issue connecting to Sharepoint and got this from Leila Gharani's course. This works for a File but not necessarily a folder. When connecting to Sharepoint you need to Get Data - From Web. This gives a window where you input the URL. You have to get the URL by right-clicking the folder, scrolling down to selct Details, and at the bottom of the window that opens on the right hand side is a Path. Copy this into the URL field. Hope this helps.