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: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
v-yingjl
Community Support
Community Support
‎06-16-2022 07:40 PM
Status changed to: Delivered

The max value for int32 data type is 2,147,483,647 while your data is 4,294,967,295 which is too large to this data type.

 

You can try to change the data type to int64 type which data range is from -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807

 

Best Regards,
Community Support Team _ Yingjie Li

danddF_1
New Member
‎06-17-2022 12:20 AM

I have the same problem : 

Error Message:
JSON integer 4294967295 is too large or small for an Int32. Path '[5].MaxLength', line 1, position 2007 and can't solve it with this solution

Anonymous
Not applicable
‎06-17-2022 03:04 AM

I'm facing the same issue. Started two days ago.

None of my rows contains the value 4294967295, but the tables causing the issues do have columns of type BigInt. The maximum size of a BigInt is 4294967295. It looks like power BI crashes on parsing the table definition, rather than the actual table data.

We have made no recent changes to the table definitions. Bug in Power BI?

@v-yingjl 

gencell_app
Regular Visitor
‎06-17-2022 06:11 AM

Cordia saludos.

 

Desde ayer no he podido actualizar la fuenta de la base de datos, me sale el mismo error de los compañeros:

 

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

 

Alguien me puede ayudar,.

 

Gracias.

Dave-ExpSC
Helper II
Helper II
‎06-17-2022 06:35 AM

I have the same problem accessing tables and refreshing data from a mysql database. It was working fine and stopped working and I had not made any changes. I believe it started with the June update.

It is happening to all of my files that access this database. I even get this error message in Desktop when - in a new file - I try to access ANY of the data tables ---- even something as simple as a Brand table (Brand names and IDs --- no large number sets).

Strangely, my published reports are performing scheduled refreshes properly.

It's only a problem in Desktop.

BTW - all other pbix files with other customers - accessing sharepoint sites or excel datasets are working properly.

Please help - this is a stop work issue - for me and my customer.

ocnos
New Member
‎06-17-2022 06:59 AM

Same problem when update.  Two similar .pbix with two diferents mySQL databases.

 

More error details:

 

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.106.582.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.AnalysisServices.QueryEvaluator.TableSchemaResult","Error":"Newtonsoft.Json.JsonReaderException","MethodDef":"FromTextResult","ErrorOffset":"0"}

 

No problem when you update in Power Query, only in Desktop june update.

redbenn
Advocate I
Advocate I
‎06-17-2022 09:56 AM

@v-yingjl your solution is marked "Delivered" but does not solve the issue. This appears to be an actual bug in PowerBI as it is happening to multiple users w/ MySQL connections not an actual Int32/Int64 discrepency as you suggested.

 

I am also experiencing the same issues described above.

jasonbub_seasi
New Member
‎06-17-2022 05:21 PM

Hi,

 

A solution has been found.  See below.

 

I can confirm that this is also happening to me.  It just started yesterday.  I had refreshed this data set many times before yesterday and it worked just fine.  I don't recall updating PowerBI, but I may have forgotten doing it.

 

This is the error:

Error Message:
JSON integer 4294967295 is too large or small for an Int32. Path '[33].MaxLength', line 1, position 12296.

 

This is the version:

Version: 2.106.582.0 64-bit (June 2022

 

Database: MySQL 5.7

 

SOLUTION: (referenced by: @dgw_REA here: https://community.powerbi.com/t5/Issues/Issue-connecting-to-MySql-database/idc-p/2586480#M81052)

 

  1. Go to Transform Data
  2. Select all Columns in your data set
  3. Click Transform > Detect Data Types
  4. Close and Apply
  5. Refresh Data

 

Jason

marcjb
New Member
‎06-18-2022 01:53 AM

Hi 

This seems to be from an update.
The problem seems to be:
Data_type = longtext

All other field formats seem OK.

Either change field type or select field in power query and press 'detect data type'

murilocfarias
Regular Visitor
‎06-18-2022 10:02 AM

I'm using Power BI to generate DashBoards from a My SQL DB and so far everything was fine. But overnight, it gave me the following error message when updating:  hospede clientes - JSON integer 4294967295 is too large or small for Int32. Caminho '[35].MaxLength', linha 1, posição 12979.

I also saw that it quotes a "position", but I don't know how I can find it within Power BI. Does anyone have a suggestion on how I can proceed? Can I find this problem by transforming the data (step before loading the data)?

Idea Statuses