Forum Discussion

SanketSk's avatar
SanketSk
Frequent Visitor
3 years ago
Solved

Import data from SharePoint List (Excel) attachment

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, in...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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's avatar
    at1222
    Regular Visitor
    2 years ago

    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?