Retrieve attachment from SharePoint online list

Hi, 

I'm currently using this solution and it looks great. However, since explanding the table and extracting the link the list item, the Power BI file it increadibly slow to update from the server. When I click "Close and Apply" to exit the query editor, the Apply Query Changes window appears but the data download rate is in the order of 1mb/min. For refernce, it is usually ~100 mb/min. 

Do you have any suggestions on what might be causing this behaviour? 

Thanks in advance,

Daniel 

Hi Mallev,

I would like to display image from sharepoint attachment in Power Bi. I tried your method. i don't understand the last step.

6. Add the custom column to your table visual and in formatting/values select URL Icon true to keep tidy.

Could you tell me where to select URL Icon true?

if I change to data category to imageURL, it will show broken files.

i hope your method can solve my problem.

Thank you.

Lisa

Hi, 

Sorry I realise this is an ancient post but I've looked everywhere for the "Attachmentfiles" column and I can't seem to find it. All I have is a column called "Attachments" when viewed in SP it displays the paper clip and if you click on the list items the attachments are there. 

however in powerbi it just shows a number 1 (not even reflective of the actual number of attachments) and it is not expandable. 

Any help would be appreciated.

This works fine for me BUT I have more than one attachment in each row within my SharePoint list.  Therefore I get more than one row with duplicated information showing the second/third/forth attacdhments.  Is there a way to combine this so that the attachments are on one row?

Thanks in advance!! (",) 

Thank you Mallev 

Hi,

I would like to display images which are stored in sharepoint as attachments. I am able to retrieve the URL, but when I use an image visualisation, I get a "broken image" icon.

However, if the user is already logged into sharepoint, then the images appear.

How can i get the images to appear without forcing the user to log onto sharepoint (before they run the report)?

I have tried formatting the URL as an image type, this does not work.

Has anyone done this?

Mallev,   Awesommmmme solution!!!!!!!  Thanks so much for sharing this truly outstanding solution!!!!  Now I can access the data and the attachments all from within Power BI!

Hi LisaChai12 

I used Mr Mallev method but I am getting on Link icons not the images.

Anonymous 
You have to use the "Implementation 1.0" for your connection, than the "AttachmentFiles" will be shown.

I cannot expand the Attachment Files colunm. It says no colunms to show instead of showing the attachment related colunms to select. Any ideas?

I Also had the same problem here, whenever i use the serverrelativeurl table for attachment it would slow down the query load like only 30Kb/s

is there anyone had a trick to solve this??

I did this change SiteUrl and listname

let
baseurl = "https://powersul.sharepoint.com/sites/SiteUrl/_api/web/lists/GetByTitle('listname')/",
itemcount = Json.Document(Web.Contents(baseurl & "ItemCount", [Headers=[Accept="application/json"]]))[value],
skiplist = List.Numbers(0, Number.RoundUp(itemcount/5000), 5000),
#"Converted to Table" = Table.FromList(skiplist, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Skip"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Skip", type text}}),

// Adicionando o endpoint para buscar a lista com os anexos
fieldselect = "&$top=5000&$expand=AttachmentFiles",

Custom1 = Table.AddColumn(#"Changed Type", "Items", each Json.Document(Web.Contents(
baseurl & "/items?$skipToken=Paged=TRUE%26p_ID=" & [Skip] & fieldselect,
[Headers=[Accept="application/json"]]
))),

#"Expanded Items" = Table.ExpandRecordColumn(Custom1, "Items", {"value"}, {"value"}),
#"Expanded value" = Table.ExpandListColumn(#"Expanded Items", "value"),

// Expandir os metadados normais
#"value Expandido" = Table.ExpandRecordColumn(#"Expanded value", "value", {
"Id", "Title", "Attachments", "AttachmentFiles"
}, {
"Id", "Title", "HasAttachments", "AttachmentFiles"
}),

// Expandir a coluna AttachmentFiles para obter os detalhes dos anexos
#"Expanded AttachmentFiles" = Table.ExpandListColumn(#"value Expandido", "AttachmentFiles"),
#"Final Expand" = Table.ExpandRecordColumn(#"Expanded AttachmentFiles", "AttachmentFiles", {
"FileName", "ServerRelativeUrl"
}, {
"FileName", "AttachmentUrl"
})
in
#"Final Expand"