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 problem?

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

4 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity 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).