Forum Discussion

dgw_REA's avatar
dgw_REA
Frequent Visitor
4 years ago
Solved

JSON integer is too large or small error

Hi All -  I am looking for help with a Power Query error on an existing report that has refreshed in PowerBI desktop perfectly fine until this morning. The resulting error is as follows. "JSON in...
Need Help
  • Powerjemarr123's avatar
    Powerjemarr123
    4 years ago
    Hello,

You must convert the data to int64, this can be done through power query in the following button

     

     

     

Ai_'s avatar
Ai_
New Member
4 years ago

For me, the problem was being caused by a string field coming from a MySQL database view.

The first 1000 rows of the field were NULL, but further down the table there were values in the field.

The standard PowerQuery detection of the datatype for the field doesn't look beyond the first 1000 rows (it even tells you this as a comment in the footer ("Column profiling based on top 1000 rows"). So if they are all NULL (as mine were) it gets the data type wrong, and later when you try to load the entire table you get an error.

Choosing the "Detect Data Type" option from the Transform tab, did sort the problem out for me. In my case this was only after I had added and removed columns until I found the one that was causing the issue. Only then did I find this post and realise that if I'd selected all the columns and chosen "Detect Data Type", it would have sorted it without the pain.