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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hello there. 

    I was following the instructions on the presented link for the image import: https://powerbipoint.com/2024/02/05/how-to-embedding-base64-images-in-power-bi/

     

    Now I've reached the last step which is "Creating a DAX measure to group chunks of the same image"

     

    When I follow the instructions my measure fails and says:

    Could you please help me with this situation.

     

    I'm trying to import images from Sharepoint so I can later upload PoweBI dashboard to Junction.

     

    Thank you in advance