Forum Discussion
Base64 Images
Hello,
I have searched endlessly for this solution and every thread seems to go into a dead end.
I would like to know how to show images that are already encoded in Base64. I have a PowerApp that can take pictures and stores the image data(format) in a SP list. The results from the PowerApp to the SP list for an image are "data:image/jpeg;base64,/.... I am using PowerBi desktop and my images do not display. Can anyone help ?
Thanks !
Hi mmattar ,
Actually, PowerBI has a limitation in the size of Base64 column, but I haven't found a document describing this. Besides, we can't find a method to reduce the size of Base64, you can consider reduce the quality of image and convert it to Base64 again.
As a workaround, we can upload the image to server, then use the image url to display it.
Best Regards,
Teige
Hi mmattar ,
Some Online storage provider like Azure or Onedrive can provide the web url for a picture, https://www.fourmoo.com/2017/09/26/power-bi-using-onedrive-to-embed-and-host-images-for-power-bi/
Best Regards,
Teige
16 Replies
I read that if the encoded Base64 column reaches max limit that the image does not show in full, this just happened to me, i see the image but its cut off. anyway to shorten the Base64 format to view the whole image ?
the character limit for a string is 32,766, anyways of reducing ?
Hi mmattar ,
Actually, PowerBI has a limitation in the size of Base64 column, but I haven't found a document describing this. Besides, we can't find a method to reduce the size of Base64, you can consider reduce the quality of image and convert it to Base64 again.
As a workaround, we can upload the image to server, then use the image url to display it.
Best Regards,
Teige
Hi ,
You can do in power BI but their is limitation
Add you r convert column image base64code
And In Power BI Desktop Model.Data,andDesign tab click the Data tab abd change the image base64code column Data catogert as Image URL after that take one grod and add the image base64code column , limitation is image size big image cant display
Check Chris Webb's blog here:
Hi, I'm a custom control developer.
My product, Image Pro, is one of the most popular options for displaying Base64 image data. And Image Pro is a certified visual.
What is the limitation for displaying large files i.e when Base64 doesn't fit into Power BI column (over ~30k characters)? Or do you have a visual that can display pdf (up to 400kB)
Using the approach in Chris Webb's blog, you can split the file into smaller chunks, each of which are less than 32,000 bytes. Then you create a measure that combines the chunks, as shown in his blog.
You can download the sample pbix of Image Pro from AppSource which shows how this works. The background images are stored in chunks as they are over 32,000 bytes.
