Forum Discussion

Helper III

1 year ago

Solved

Memory failure: While attempting to store a string, a string was found that was larger than the page

I hope you can help I am getting data from the active directory through the connector. I want to get the Thumbnail photo. For some photos I get the error above in the title. I think the String is...

Need Help

lbendlin
1 year ago
The Power Query string length limit is 32K

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

Anonymous

Not applicable

1 year ago

Hi JB_AT ,

Please check whether the reply in this case helpful?
Memory error - Microsoft Fabric Community

If not, You can try truncate the String in Power Query. For example:

let
    Source = ... ,  // Your data source here
    TruncateThumbnail = Table.TransformColumns(Source, {{"ThumbnailPhoto", each Text.Start(_, 1000), type text}})
in
    TruncateThumbnail

Or you can try compressing the String. For example:

let
    Source = ... ,  // Your data source here
    CompressThumbnail = Table.TransformColumns(Source, {{"ThumbnailPhoto", each Binary.ToText(Text.ToBinary(_, TextEncoding.Base64)), type text}})
in
    CompressThumbnail

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.