Forum Discussion

TMA's avatar
TMA
Frequent Visitor
2 years ago
Solved

SVG text being cut when imported

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 Te...
Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    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?

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
2 years ago

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?