How can I display images from SharePoint Online List in PowerBI Report?

[Anonymous]

Hello Together
does anyone know how I can display the full images from my SharPoint Online List? With this solution "Retrieve attachment from SharePoint online list" I see the images as broken-image-symbol... is there another solution for that?

[Noche70]

Ok, I managed to import the images from Sharepoint List to PowerBI, the only issue is, I have over 300 images, how do I optimize them before importing them to PowerBI? maybe using a thumbnail? I am using 365, not desktop apps.

[lbendlin]

Remember that these images will be consumed in a web browser with low dpi.  Downsample them as much as possible so they still convey your story but they should not take up more than 128KB.  Ideally less than 32KB so they can fit into a single string.

[Anonymous]

Hi  @Anonymous ,

Please refer to the following blog to see if it helps you.

COMPLETE GUIDE TO EMBED IMAGES IN POWER BI REPORTS (PART I) 

1. Open Power BI desktop 
2. Click on Enter Data 
3. Now paste SharePoint image URLs with names and descriptions.

If I have misunderstood your meaning, please provide more details.

Best Regards

Community Support Team _ Polly

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

[Anonymous]

Hello @Anonymous 

i also tried this solution last week (all three parts) but this solution only works with the source option "Sharepoint Folder". This solution requires a "Content" column (binary data) which is not created in the "Sharepoint Online list" during the query... 

[lbendlin · Accepted solution]

first step - extract the URL from the list item (in this case the column is called [Pic])

let
    Source = SharePoint.Tables("https://xxx.sharepoint.com/teams/yyyGroup", [Implementation="2.0", ViewMode="All"]),
    Link = Source{[Id="list id here"]}[Items],
    #"Added Custom" = Table.AddColumn(Link, "Custom", each [Pic][serverUrl] & [Pic][serverRelativeUrl])
in
    #"Added Custom"

That gives you the absolute image URL.  Now you can decide if you want to try and display it live (likely resulting in the broken link), or if you want to incorporate the image into your dataset (preferable). This blog has details on how to achieve that in general: Chris Webb's BI Blog: Storing Large Images In Power BI Datasets Chris Webb's BI Blog (crossjoin.co.u...

[lbendlin]

Keep in mind that the Power BI service needs to be able to access your Sharepoint list in order to retrieve the images. Generally you do NOT want to give them that permission.

A workaround is to force the sharepoint connection through an On-premise gateway even though technically that is not necessary.

The best option would be to incorporate the images into your Power Query data source pull instead. There are articles that describehow to chop up images into 32K chunks, and then how to stitch them back together in Power BI visuals.

[Anonymous]

Hello there. 

I was following the instructions on the presented link for the image import: https://powerbipoint.com/2024/02/05/how-to-embedding-base64-images-in-power-bi/

Now I've reached the last step which is "Creating a DAX measure to group chunks of the same image"

When I follow the instructions my measure fails and says:

Could you please help me with this situation.

I'm trying to import images from Sharepoint so I can later upload PowerBI dashboard to Junction.

Thank you in advance

[lbendlin]

your screenshot is not readable.

[Anonymous]

Sorry about that. I've edited the post, so hopefully, you can see it now. I've found multiple solutions for other situations related to the same error, but not for images. Thank you in advance.

[lbendlin]

the name of the table where you store the chunks doesn't seem to be "images".

[Anonymous]

I've used the same link for image to import it manually (Enter data) and then publish it and open it online where the picture is visible. Don't know what seems to be the problem, followed the instructions step by step...