Embed png image in powerbi using Base64 not concatenating correctly

[Asina]

I have used the following guide to split the images from .png files into sizes less than 30000 characters: https://www.alphabold.com/complete-guide-to-embed-images-in-power-bi-reports-part-iii/ 

Everything goes perfect and I get to split the images into base64 into multiple rows with the same name but changing indexes. 

However, when I try to gather the rows into a single row using the second part of the guide, where you use the function "concatenatex" in measure, It does not concatenate the rows based on the name and index as it should. 

instead every row shows the value of PIC based on the Name column and index. instead of just concatenating them.

see the picture below: 

The whole idea is that in dax we have larger cell capacity and thus the splittet text from query should be able to be gathered into 1 and used to reconvert into the real image. 

See the link above for the intended use.

However it all works until the concatenation, which is not working as intended. 

[rsbin]

@Asina ,

I just went through a similar exercise late last week.  I was able to get it to work.  Here is my Measure:

DisplayImage = "data:image/jpeg;base64," & CONCATENATEX('Base64', 'Base64'[Text], , 'Base64'[Index], ASC )

Instead of jpeg, I think you might need to use png.

My Base 64 example was approx. 420,000 characters, so needed to split into 15 segments.

Hope you can make use of this.

Regards,

[Asina]

Thank you for your reply.

I have tried and I get the same problem, which is that the concatenate function is not really "concatenating" the 3 row with index 0-2.

on top of that, if i use measure and display the measure in a table or something, it says: "

Error Message:
MdxScript (Model) (4, 24) Calculation error in measurement 'Charts' [Image]: The 'PLACEHOLDER' function found a text exceeding the maximum allowable length. 

[rsbin]

@Asina ,

I have a couple of suggestions.  Based on the error message, is to double check the character length of your text strings. 

The other would be to draw the image one row at a time and to see if it fails at a specific row.

In your Measure, only include one index at a time.

Other than that, not sure what else it could be.  This image stuff is new to me as well.

Regards,