Forum Discussion

andy_scott42's avatar
andy_scott42
Helper II
7 years ago

Base64 images not displaying correctly

I have images stored as binary in a database field. I am converting these to base 64 and using a Dax expression to create the following dataset column : ="data:image/jpeg;base64, " & [ImageBase64]

 

Most of the images are displaying fine but some are being cropped:

 

I've checked the size of the images and none of them are more than 500x500px or more than 1MB.

 

Any ideas what may be causing it?

 

I've created a simple SSRS report table and they display fine there. Is it something to do with converting to base64?

 

Thanks

 

Need Help

2 Replies

  • andy_scott42's avatar
    andy_scott42
    Helper II
    7 years ago

    I've discovered it is because the length of the base64 string is greater than the max accepted string length in Power BI (32766 characters).

     

    Is there a way to reduce the size of an image in the data model or can I do it via SQL server/ another package?

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Hi andy_scott42,

       

      I'm afraid you should compress the image string data size in database because power bi doesn't support such feature. You can submit your idea here: https://ideas.powerbi.com.

       

      Regards,

      Jimmy Tao