Forum Discussion

jlbam's avatar
jlbam
Regular Visitor
7 months ago
Solved

Displaying images from a SharePoint library image column

Hello,   I’ve been trying to display images stored in an Image column in a SharePoint library by composing the final image URL using the serverUrl and serverRelativeUrl fields.   When pasting the...
  • Irwan's avatar
    7 months ago

    Hello jlbam 

     

    I faced same as you. But as i explored, some computer load the pictures and some dont if the link is coming from sharepoint.

     

    The reliable way is using public url as you mentioned and base64 format.

    Those two surely load the image. However, converted into base64 has character limit limitation in column so you need you need to split column then rejoin in measure.

     

    Hope this will help.

    Thank you.

  • jlbam's avatar
    jlbam
    7 months ago

    Thank you, Irwan.

    Upon further research into the topic you mentioned, this is what worked for me: using the SharePoint.Contents connector in Power Query to retrieve the content of the image files and convert them to base64.

    For anyone interested, a detailed tutorial can be found here: Embedding Images Without URL | Base64 Encoding Method in Power BI