Forum Discussion
Binary to Image - Size Limit
- Anonymous2 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
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.