Display Sharepoint images in Power BI

[danextian]

Hi,

I've read several tutorials on how to display sharepoint images in Power BI.

http://www.axioworks.com/2017/04/how-to-import-sharepoint-libraries-into-power-bi-and-create-links-t... The tutorial from this site works if a URL is set as a Web URL (as I can click the link and image will display). However, setting the link as Image URL does not work as the table I added the link to shows no images - just a column with blank cells.

[AStolk]

The solution above helped me for retrieving and displaying images which are located in a specific document library. Awesome! So far, so good.
But I also need to receive images from several sites: each site has a document libray "Shared documents" with a folder "Images" and I need its content of these particular folder for each site, preferrably as a list with a site id or site url path. Should I do something with a SharePoint Search query to achieve this? Or maybe a function in Power Query? In Power BI I have all the URL values for the sites so in my opinion there should be a way to use these url's to dynamically get the path the de "Share documents/Images" folder and its content. But how?

[v-chuncz-msft]

@danextian,

Check if the following thread helps.

https://community.powerbi.com/t5/Service/Dashboard-Image-Tile-Image-not-loading-from-provided-URL/td...

[danextian]

Hi @v-chuncz-msft

Thanks for the link but none of the solutions presented solves my issue as I am not getting any  permission prompt/error and the URL just loads fine I used it in a dashboard tile. It's just that the matrix/table is not showing the images although i've already set data category to image.

[THEG72]

@danextian @v-chuncz-msft 
I have found the best way to access images on a sharepoint folder for my power bi reports is using a dataflow that converts it to BASE64.

Setup a Dataflow to point to sharepoint image folders and convert them to BASE64 per Chris Webbs Blog.

The only difference is instead of Folder.Files you use sharepoint contents function.

Source = SharePoint.Contents("https://Yourwebsite.sharepoint.com")

Once the data flow is setup in the service bring the converted base64 image table into your model pbix file.
Here is my example for country flags i use in my reports

Country Flag Image Table in BASE64

You then need DAX statement to cocatenante BASE64 string so it can display in Matrix or Table visual.

Display Country Flag = 
IF(
    AND ( HASONEVALUE ( 'DimRegion'[Country] ), [_Has Sales] ),
    "data:image/jpeg;base64, " &
    CONCATENATEX(
        FILTER ('CountryFlag', 'CountryFlag'[Name] = VALUES('DimRegion'[Country])),
        'CountryFlag'[Pic],
        ,
        'CountryFlag'[Index],
        ASC)
        )

This seems to best result and least impact on model size and speed of operation.