Forum Discussion
Resolver IILoad Excel file attachment directly from SharePoint online lists
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
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.
4 Replies
gancw1I 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.
- amitchandak
Super User
gancw1 , I usually remove :x/:r from the url
https://www.youtube.com/watch?v=xaPOoBUqeYs
https://www.youtube.com/watch?v=t4TzHu8THoA
- gancw1amitchandak 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
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.
