Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am looking for help with a Power Query error on an existing report that has refreshed in PowerBI desktop perfectly fine until yestrday morning. The resulting error is as follows.
"JSON integer 4294967295 is too large or small for an Int32. Path '[25].MaxLength', line 1, position 9475."
Where do I look for the error based on the line and position given and is this in the Power Query Advanced Editor?
Is it soley limited to the 1 queries the error is referencing or could it be in one of the others and connected with lookup columns?
Should I be looking at changes within the data source?
Is this a known or new issue that others are seeing? I appreciate any help provided.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @dgw_REA ,
We have seen shares from other users in the forum:
”Users can try Detect Data Types in Power Query Editor before loading data into Power BI Desktop.“
No other workaround for now.If there are other users who have a better way to solve this problem, you are welcome to leave this valuable answer in the post
Best Regards,
Community Support Team _ Caitlyn