Getting Image URLs to display Image

[lukas_alex]

I currently have a colum that references a image URL on another table based on the value but when I put these in a visual the image does not show up and I am only given the URL.  How can I get the image to show up?

[Tangi12]

I am having the same issue. Images on sharepoint. (really my only option) and images do not show.  This shouldn't be this difficult...

[Brenda-zyc]

Same issue. Images are on Sharepoint. Have you found any solutions?

Thx!

[Anonymous]

It works only for a day, but the image URL will be different the following day. Any idea how to solve this issue?

[aliozturkmen]

Hi; 

Have the same issue.

Did you find a soliution? 

I think the address of the images in Sharepoint is changing depending on the day or user.

[Juliecal73]

Hi,

I have a similar issue. The picture displays if I use the AD conversion path, but when I try and use the O365 links below (all of which return an image in the browser) the vizuals do not display the image.

Is this because it is not specified as an image type? If so, how is that done with the below?

Or is it an authentication issue with getting a user image from O365?

https://outlook.office365.com/ews/Exchange.asmx/s/GetUserPhoto?email={user@email}.com&size=HR96x96
https://outlook.office365.com/owa/service.svc/s/GetPersonaPhoto?email={user@email}.com&UA=0&size=HR96x96
https://outlook.office365.com/owa/service.svc/s/GetPersonaPhoto?email={user@email}.com&UA=0&size=HR96x96&sc=1587223657595

Thoughts?

[Anonymous]

I also tried to use O365 links without success. I believe is an authentication factor.

[Anonymous]

Aquí les adjunto un código que desarrollé con ayuda del siguiente vídeo de youtube (Guy in a cube) y blog (Chris Webb). Son demasiado útiles.

https://www.youtube.com/watch?v=Q82yzcfkqAc

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/

DAX code usando una tabla con image64 bits, Nombre, extensión de archivo, tipo de actividad y fecha de archivo

SplitTextFunction = Splitter.SplitTextByRepeatedLengths(30000),     //Converts table of files to list     ListInput = Table.ToRows(#"Reordered Columns"),     //Function to convert binary of photo to multiple     //text values     ConvertOneFile = (InputRow as list) =>         let             BinaryIn = InputRow{​​​​​​0}​​​​​​,             Name_image = InputRow{​​​​​​1}​​​​​​,             Extension = InputRow{​​​​​​2}​​​​​​,             Activity = InputRow{​​​​​​3}​​​​​​,             Date = InputRow{​​​​​​4}​​​​​​,             BinaryText = Binary.ToText(BinaryIn, BinaryEncoding.Base64),             SplitUpText = SplitTextFunction(BinaryText),             AddFileName = List.Transform(SplitUpText, each {​​​​​​Name_image,Extension,Activity,Date,_}​​​​​​)         in             AddFileName,     //Loops over all photos and calls the above function     ConvertAllFiles = List.Transform(ListInput, each ConvertOneFile(_)),     //Combines lists together     CombineLists = List.Combine(ConvertAllFiles),     //Converts results to table     ToTable = #table(type table[Name_image=text,Extension=text,Activity=text,Date=date,Pic=text],CombineLists),     //Adds index column to output table     AddIndexColumn = Table.AddIndexColumn(ToTable, "Index", 0, 1) in     AddIndexColumn

[Anonymous]

Same issue here...any solution ?

[deldersveld]

If you select the field and go to the Modeling tab, verify that the Data Category is set to Image URL. 

[lukas_alex]

I have changed it but the image is still not showing up and I am just getting the URL.  Is there a specific format the image needs to be saved as?

[v-yuezhe-msft · Accepted solution]

@lukas_alex,

Could you please post sample data of the image column? In Power BI Desktop, images work for URL that over web not local path, you can review the following example.



Regards,
Lydia

[Ramitos]

Good afternoon

I have my images local path, any sugeestion how to get them in Power Bi?

[Anonymous]

Hi. But  can i insert somehow a hyperlink to another site in this image? 

[Anonymous]

Hi,

I also have a similar problem. 

I already set the data category to Image URL.

I found that it works if I use Google images or from Web, but I tried to upload my images to IMGur or my Sharepoint and it shows broken image

Is there any recommendation on which webiste I should upload my image so that it works better?

Thanks so much in advance @v-yuezhe-msft @deldersveld 

Best regards

Kevin

[rsarapalli]

I want to display the Power BI Dashboard as an image. I am using Cluster Map visualization in Power BI and trying to save the https: //hq - powerbi***    link ending with .jpg, in the Image URL field. But I can't see the image in Cluster Map visualization. Is it possible to use the Power BI dashboard link to show up as an image? Kindly advice.

[Queen_Geek]

I didn't see a solution for the SharePoint question.  I'm having the same issue.  Any solutions?

[lukas_alex]

I was using a local path that is why it was not showing up.  I got it to work now! Thank you!