display attachments from SharePoint list in PowerBI report table

[ppl]

Hello.
I want to display attachments(photos) from my SP list in my report.

It will be Table visual element.

But there is only True or False value in attachments column:

[v-janeyg-msft · Accepted solution]

Hi, @ppl  

After my test, The URL of the picture added to 'attachment' will not be displayed in the pbi, it can only detect whether there is content, just like true and false you see. But if you add image type, there will be one text column 

to show the image url, and you need to separate the text and then reorganize the complete url, and change the data category of this column to image url in pbi, then publish it to pbi service,the images can be shown.

PQ steps: you need to split column and create a custom column to combine the part of serverurl and serverrelativeurl to a whole image url.

let
    Source = SharePoint.Tables("https://xxxxxxxxxxx.com/", [Implementation=null, ApiVersion=15]),
    #"cc275f95-925d-48d4-bd10-bc8baae49d8d" = Source{[Id="cc275f95-925d-48d4-bd10-bc8baae49d8d"]}[Items],
    #"Split Column by Delimiter" = Table.SplitColumn(#"cc275f95-925d-48d4-bd10-bc8baae49d8d", "test1", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"test1.1", "test1.2", "test1.3", "test1.4", "test1.5", "test1.6", "test1.7"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"test1.1", type text}, {"test1.2", type text}, {"test1.3", type text}, {"test1.4", type text}, {"test1.5", type text}, {"test1.6", type text}, {"test1.7", type text}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"ID", "ID.1"}}),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Renamed Columns", "test1.5", Splitter.SplitTextByEachDelimiter({":"}, QuoteStyle.Csv, false), {"test1.5.1", "test1.5.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"test1.5.1", type text}, {"test1.5.2", type text}}),
    #"Split Column by Delimiter2" = Table.SplitColumn(#"Changed Type1", "test1.6", Splitter.SplitTextByEachDelimiter({":"}, QuoteStyle.Csv, false), {"test1.6.1", "test1.6.2"}),
    #"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"test1.6.1", type text}, {"test1.6.2", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type2", "Custom", each [test1.5.2]&[test1.6.2])
in
    #"Added Custom"

Desktop:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[VahidDM]

Hi @ppl 

Check this link:

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-images-tables

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

Appreciate your Kudos✌️!!