Forum Discussion

mmattar's avatar
mmattar
Frequent Visitor
7 years ago
Solved

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

    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

mmattar's avatar
mmattar
Frequent Visitor
7 years ago

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 ? 

TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

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

  • mmattar's avatar
    mmattar
    Frequent Visitor
    7 years ago

    Hi TeigeGao , can you elborate a bit more on "we can upload the image to server, then use the image url to display it" 

    Thanks

      • guh950's avatar
        guh950
        Microsoft Employee
        4 years ago

        How would I do something like this programmatically through Power BI's power query editor for a OneDrive Folder?

         

        Currently, I created a custom column to convert the image to Base64, and ran into the clipping issue mentioned above, and I created a custom column that concatinated the file name and folder path and applied the picutre url category to it, but to no avail. So short of going into the image folder and manually resizing each image one by one, and testing until unclipped, I'm not sure if there's a way to auto generate the embedded url for each image. I'm all about saving time haha.