Forum Discussion
Getting Image URLs to display Image
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?
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
18 Replies
If you select the field and go to the Modeling tab, verify that the Data Category is set to Image URL.
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?
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
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=1587223657595Thoughts?
- 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.DAX code usando una tabla con image64 bits, Nombre, extensión de archivo, tipo de actividad y fecha de archivoSplitTextFunction = 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
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.
I was using Sharepoint images which showed up for some and not for others.
After a lot of research, these two solutions solved my problem:
1) Embed the images within your report (Base64)
2) For Sharepoint images: embed the Power BI report on a Sharepoint page
Source: this article details these solutions and reasons for the image problem
