Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

0
robq

Int32 Error when Refreshing Data Table

Submitted by on ‎06-16-2022 02:26 PM

Hey, I am attempting to refresh our data source, but I run into an error that looks like this:

 

Error Message:

JSON integer 4294967295 is too large or small for an Int32. Path '[8].MaxLength', line 1, position 3149.

 

I am not sure where this is pulling from. It seems when I go through and individuall try to refresh tables, the error occurs from a table that is connected to an external DB.

 

What does this error mean and where is it originating from in PowerBI?

Status: Delivered

Thanks @jasonbub_seasi  and @marcjb  sharing the solution about this issue which would help users on the community who may have the same issue:

 

Users can try Detect Data Types in Power Query Editor before loading data into Power BI Desktop.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
14 Comments (14 New)
Comments
redbenn
Advocate I
Advocate I
‎06-19-2022 10:42 AM

@marcjb that worked for me. Thanks!

v-yingjl
Community Support
Community Support
‎06-19-2022 05:49 PM
Status changed to: Delivered

Thanks @jasonbub_seasi  and @marcjb  sharing the solution about this issue which would help users on the community who may have the same issue:

 

Users can try Detect Data Types in Power Query Editor before loading data into Power BI Desktop.

 

Best Regards,
Community Support Team _ Yingjie Li

Dave-ExpSC
Helper II
Helper II
‎06-20-2022 08:11 AM

Hi @Anonymous

This solution did nto work for me. In Power Query I selected the columns in the tables and used Detect Data Type. I noticed that it did make a change to Int.64 
I did this for every table. Before I left Power Query I went through all tables and made sure they were Refreshed.

Closed out and it fails to Apply the changes after spinning for a long time. The error now says it was a failure to load in another table. Every table says this. So where is the error.
My files were working for 6 months and the June update crashed it. 

I do not think this issue has been resolved. My best evidence is going back to my MySql source in a new file and I can not pull down a single table = all have the same error message "

JSON integer 4294967295 is too large or small for an Int32. Path '[5].MaxLength', line 1, position 2053."

Everything worked before. It is not an option to go to the developers of the company's mysql application and suggest they have something that they need to fix. The June update broke it and Detecting Data Type did not work for me. Microsoft please consider that this problem is NOT DELIVERED - at least not for all of us.
Please look further.

julienvdc
Helper III
Helper III
‎06-27-2022 03:36 AM

does not work...

Idea Statuses