Forum Discussion
Solved
Truncated text fileds when importing data from a JSON file
Hi, I have a JSON file with a variable text field whose length can exceed 2000 characters. When I import the file into PowerBI, the text field is truncated to 1023 characters. How can I avoid this ...
Hi,
I found a solution to my problem.
Change the import query:
- add a change of type on the column (change from non-determined to text)
After this adjustment, the column is no longer truncated :-)
Hi,
I found a solution to my problem.
Change the import query:
- add a change of type on the column (change from non-determined to text)
After this adjustment, the column is no longer truncated :-)
My datatype is already text and still the data is coming out as truncated