Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I believe this issue coincides with the June update. 2 days ago PBI Desktop stopped allowing me to refresh data and produced the following error: JSON integer 4294967295 is too large or small for an Int32. Path '[4].MaxLength', line 1, position 1697.
I tried other reports that access the same database and they also error out with this message - the position information changes.
So I opened a NEW file on Desktop and attempted to bring down some tables from the database and it errors out with the same message. Everything was working fine until the June update hit. Strangely, the published report on service being accessed by multiple individuals is still running the Scheduled Refreshes and working. It is only an issue on Desktop.
I have other reports - accessing data on customers sharepoint sites and excel datasets and all are working properly.
It's a problem because I can't do any work for this customer.
Has anyone else experienced this issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Dave-ExpSC
As @dgw_REA mentioned , he solved the issue with Detect Data Type in Power Query Editor .
Best Regards,
Community Support Team _ Ailsa Tao