Forum Discussion
How to get data from a Sharepoint subfolder using Excel Power Query?
I'm trying to use Excel's Power Query to pull data from a bunch of .csv files saved on my company's Sharepoint. We use different folders and subfolders to categorize data from different studios.
I need to get data from a specific subfolder. Its web address may look like this:
https://contoso.sharepoint.com/marketing/data/studioABC
Maybe I made some mistakes unaware, but following the instructions from this MS official doc:
https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder
The Power Query could only get data from the root folder, like the below link.
https://contoso.sharepoint.com/marketing/data/studioABC
It cannot recognize any link pointing to a subfolder.
When I tried to use the below link pointing to a subfolder in the "get data from Power Query folder", I got an error message as shown in the snapshot.
https://contoso.sharepoint.com/marketing/data/studioABC
Hence, is there a way to get data only from a specific subfolder on Sharepoint?
I'm using the Office 365 ProPlus subscription on a Win 10 Enterprise 1909.
Many thanks in advance!
1 Reply
Cross posted https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-get-data-from-a-sharepoint-subfolder-using/3bd9f97e-2536-41dc-b986-caccb31d7b7e where HyperBioGhost / https://answers.microsoft.com/en-us/profile/db99ee09-4ede-4cfa-905d-b521acdf81d1 updated the case with a https://youtu.be/-XE7HEZbQiY
