SVG text being cut when imported

[TMA]

I imported imported a folder with svg files in it, then created a new column, for example: 

let
Source = Folder.Files("C:\Users\Downloads\svg"),
Custom1 = Table.AddColumn(Source, "SVG", each Text.FromBinary([Content], BinaryEncoding.Base64))
in
Custom1

Then I used HTML Viewer to display my image but the image is imcomplete, it turns out that power bi is not importing the full text of the svg file, any ideas on how to fix this?

The one in the right is what is should look like

[OwenAuger · Accepted solution]

Hi @TMA 

The values in the SVG column may be reaching the limit of 32,766 characters. Anything greater than 32,766 characters is silently truncated when loading to the data model.

You could check this by adding a DAX calculated column

SVG Length = LEN ( YourTable[SVG] )

If that is the case, you could try the method described in this blog post, where each image is split across rows, and recombined in a measure.

https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/

If that's not the issue, could you share an example of an SVG that is not working?