Forum Discussion
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.
Is this a limit in PowerBI? Is there any workaround other than the URLs?
Thank you.
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
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.
2 Replies
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
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.Thank you, I manage to do it but there is a catch, dax can't be put on simple image sampling and I am unable to achieve images via tooltip even using Cloudscope visuals.
