Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Image Binary Data to Image

Hello,   I have a table in SQL Server which has Image binary data in the below format -      0x1F8C0200B28C010064 0x1F8C0200DE720100CC 0x1F8C0200DE720100CC 0x1F8C0200B28C010064 0x1F8C0200B28C01...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Please check if the method in this blog could help you.

     

    Step 7

    Change the data type of ImageData (Binary) column to text from the top panel's Transform tab.

     

    Step 8

    Go to "Add Column" and click on "Custom Column". It will open a window. Enter the column name and formula given below and click OK.

    “data&colon;image/<image_format>;base64,”&[ImageData<binary_column_name>]

     

    Step 9

    On Data tab, select Image column and change its data category to Image URL.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MmmVvv_23's avatar
MmmVvv_23
Frequent Visitor
2 years ago

I didnt notice any special difference between:

let 
    BinaryToPbiImage = (BinaryContent as binary) as text=>
let
    Base64 = "data&colon;image/jpeg;base64, " & Binary.ToText(BinaryContent,BinaryEncoding.Base64)
in
    Base64
in
    BinaryToPbiImage

 

and:

"data&colon;image/jpeg;base64,"&[Content]


In my table or SimpleImage viz looks all the same.