Forum Discussion

lukas_alex's avatar
lukas_alex
Frequent Visitor
9 years ago
Solved

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 im...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Juliecal73's avatar
Juliecal73
Helper III
6 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    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 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