Issue connecting mysql database

[PBI-YellowScire]

Since 3 days ago the update data process give an error "JSON integer 4294967295 is too large or small for an Int32. Path '[36].MaxLength', line 1, position 13599."

I didn´t change anything in the PBI file but the process fail, can you help me?

[v-cazheng-msft]

Hi @PBI-YellowScire,

You may try this solution.

• Go to Transform Data
• Choose navigation step
• Transform Detect Data types
• Save and Apply

Here are some similar issues may help you.

Solved: Re: JSON integer is too large or small error - Page 2 - Microsoft Power BI Community

JSON Error: Int is too large or too small - Microsoft Power BI Community

Int32 Error when Refreshing Data Table - Microsoft Power BI Community

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Solution provided.