Forum Discussion

thomas9921's avatar
thomas9921
Frequent Visitor
5 years ago

Error when loading JSON file: The type of the current preview value is too complex to display

Hello, 


I am attempting to load a JSON file into PBI, and I am getting this error:

 

The type of the current preview value is too complex to display

 

The file fairly large, 518KB. The actual data is ~400K rows and 47 columns. The datatypes are; float64, object, and int64.

 

Does anyone know why I am getting this error, and how to fix it?

 

Thanks!

1 Reply

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support

    Hi thomas9921 

     

    Here is a similar thread for your reference. Please check if the suggestion mentioned in it work for your scenario.

    If not, you might probably raise it to the support team for better advice: