cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kevin_ay_edu
Regular Visitor

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

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?

1 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...

 

 

 

 

 

View solution in original post

4 REPLIES 4
v-polly-msft
Community Support
Community Support

Hi  @Kevin_ay_edu ,

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.

 

Hello @v-polly-msft 

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... 

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
Super User
Super User

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.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors