Truncated text fileds when importing data from a JSON file

[Dom33]

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?

[v-qiuyu-msft]

Hi @Dom33,

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

Best Regards,
Qiuyun Yu

[Dom33 · Accepted solution]

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 🙂

[Anonymous]

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

[vross]

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