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', li...
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)
- Go to Transform Data
- Select all Columns in your data set
- Click Transform > Detect Data Types
- Close and Apply
- Refresh Data
Jason