Forum Discussion

mohammadyousaf's avatar
mohammadyousaf
Icon for Resolver II rankResolver II
2 years ago
Solved

Binary to Image - Size Limit

Hi everyone,  These are Binary to Image data but unfotunately I am unable to show full pictures unless I resize the source Binary Image to 25kb which is very low resolution for my requirement. ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mohammadyousaf ,

    Regarding your question, the maximum length of a text value that the Power Query engine can load into a single cell in a table in a dataset is 32766 characters. This may be the reason why your image does not display fully when it exceeds 32kb. You can do this by encoding the binary using Base64, then splitting the textual representation of the image into multiple smaller text values stored in multiple rows, each smaller than the 32766 character limit, and then reassembling them into the dax metric after loading the data.
    Details can be found in the following:

    How to load large images in PowerBi - Stack Overflow

    blog.crossjoin.co.uk

     

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