Import data from SharePoint List (Excel) attachment

[SanketSk]

Hi There,

I am writing to request your assistance with a task involving SharePoint and Power Query. I have a SharePoint list called PQattachment that contains various information and attachments, including some Excel files (.xlsx). I would like to import the data from these Excel files into another Excel workbook using Power Query. However, I am not sure how to do this and I would appreciate your guidance.

Could you please provide me with a step-by-step process to accomplish this task? If possible, please include screenshots or links to relevant resources. This would help me a lot in completing my work.

Thank you for your time and support.

Sincerely,
Sanket

[v-jingzhang · Accepted solution]

Hi @SanketSk 

For how to connect to a SharePoint List with Power Query in Excel, you can refer to How to get data from SharePoint List with Power Query (exceloffthegrid.com)

For how to extract data from attachments in a SharePoint list and combine them into a big table, you can refer to an old thread: Get and Transform Excel files from SharePoint list - Microsoft Power BI Community

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[at1222]

Hi, with extracting the data and combining it into a big table, I am having trouble with the solution provided. Would you be able to provide an example or show how to do it?