Transform to Json

[entutionbi]

Hello there,

Before I convert JSON format(text column), it does not show all the values in the field, it just shows the ellipsis. Refer Screenshot 2 . If you look at the screenshot 1 , you could see highlighted records which are not shown in screenshot 1

Source - screenshot 1

Screenshot 2

[v-stephen-msft]

Hi @entutionbi ,

This is likely to reach the string limit.

Text type

Text - A Unicode character data string. Can be strings, numbers, or dates represented in a text format. Maximum string length is 268,435,456 Unicode characters (256 mega characters) or 536,870,912 bytes.

Best Regards,

Stephen Tao

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