Answered

Extract data from a folder with excel files saved on sharepoint

(0) Share

Report

Posted on 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

Categories:

Power Query

I have the same question (0)

All responses (3)

Answers (0)

aravind_p_m 12 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MI-15011544-0 2 on at

Like (0)

Report
Copy link

Link copied!

How do you manage to do so. I am having issue "Bad Request"

Was this reply helpful? Yes No
DJ-18050331-0 5 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No