Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Transform to Json

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




Community Support
Community Support

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.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors