Answered

Extract data from a folder with excel files saved on sharepoint

Like (0) Share

Report

Posted on 8 May 2023 13:11:24 by aravind_p_m

Hello all.
I need help to know how I can extract data from Excel files saved in a folder on SharePoint.
I have been able to link files on OneDrive with no issues. Now I need to rewrite the query to extract data from a folder on SharePoint. I am getting stuck linking the source file to the query.

Aravind

All responses (3)

Answers (0)

DJ-18050331-0 2 on 18 May 2025 at 03:44:24

Like (0)

Report

Extract data from a folder with excel files saved on sharepoint

Hi Aravind,

Was your post answered? I have a similar question and cannot find an answer

I see you replied "Thanks for the directions. Your guide helped me connect to the files using Power query. I was able to retrieve the data from the folder in the SharePoint folder" but I do not see the directions you mention?
MI-15011544-0 2 on 15 Jan 2025 at 15:50:09

Like (0)

Report

Extract data from a folder with excel files saved on sharepoint

How do you manage to do so. I am having issue "Bad Request"
aravind_p_m 12 on 10 May 2023 at 13:39:09

Like (0)

Report

Re: Extract data from a folder with excel files saved on sharepoint

Thanks for the directions. Your guide helped me connect to the files using Power query. I was able to retrieve the data from the folder in the SharePoint folder