Forum Discussion
dgw_REA
4 years agoFrequent Visitor
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...
- 4 years ago
Hello, You must convert the data to int64, this can be done through power query in the following button
pmargari
4 years agoAdvocate II
Same problem and without any changes just start getting this error on desktop
- Powerjemarr1234 years agoNew Member
Hello, You must convert the data to int64, this can be done through power query in the following button- pelloetxeberria4 years agoRegular Visitor
I confirm that the following has worked for me: Enter Power Qwery editing mode, select ALL the columns and click (to add the process step) the Transform>Detect Data type button. Many thanks to all
- Avry_th4 years agoFrequent Visitor
it works for me, thank you so much
- dgw_REA4 years agoFrequent Visitor
that's it! Thank you! I selected all columns and then selected Detect Data Type.
- pmargari4 years agoAdvocate II
Great tip Powerjemarr123 ,fix it !!!
Thanks for your contibution really appreciated as could't found any fix for this
KR
- dgw_REA4 years agoFrequent Visitor
same