Forum Discussion

Dom33's avatar
Dom33
Regular Visitor
9 years ago
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 ...
Need Help
  • Dom33's avatar
    Dom33
    9 years ago

    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 :-)

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Dom33,

 

I have reported this issue internally, will update here if I get feedback.

 

Best Regards,
Qiuyun Yu

Dom33's avatar
Dom33
Regular Visitor
9 years ago

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 :-)

  • vross's avatar
    vross
    Frequent Visitor
    8 years ago

    I don't find that this fixes the problem when my text is in an excel table.  (Using Power Query inside Excel).

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    My datatype is already text and still the data is coming out as truncated