Load Excel file attachment directly from SharePoint online lists

[gancw1]

I am trying to do this by extracting the attachment URLs and calling Web.Contents( ) to extract the Excel tables.  However PQ does not allow multiple calls to the same API - in this case an API call to retrieve the Sharepoint list and another call to get the attachments.

Another post mentions a workaround that uses PowerApp to push the attachments to a Sharepoint Library. 

Solved: Re: Load data from Excel file attachment in ShareP... - Microsoft Fabric Community

Is there a way to acheive this without needing to use Power App to push attachments to a library ?

Thanks

[gancw1 · Accepted solution]

I managed to overcome the error by using SharePoint.Contents( ) to directly access all the attachments in the list

I can now expand the Attachments table and then use Excel.Workbook( ) to read in the Excel content from all the attachments.

[Anonymous]

Hi @gancw1 ,

Navigate to Excel on Sharepoint using a browser. select the ellipsis (...) to open the More menu, then select Details. In the More Details pane that appears, select the Copy icon next to Path.

In Power BI Desktop, select Get data > Web, paste the link into theFrom Webdialog.

You can also use a SharePoint folder as a source.

Please see these tutorials for more information.

Get Excel Data from a Single File or Entire Folder on SharePoint 

Use OneDrive for Business links in Power BI Desktop 

Video:

Youtube_Link Power BI to an Excel file in SharePoint Online 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[amitchandak]

@gancw1 , I usually remove :x/:r from the url

https://www.youtube.com/watch?v=xaPOoBUqeYs

https://www.youtube.com/watch?v=t4TzHu8THoA

[gancw1]

@amitchandak Thanks for responding.

I don't quite get your response. I would like to load Excel attachments from a Sharepoint list. This should be a common use case but I can't find any solution