Forum Discussion
JSON Serialization String Length Error
Hello @rbowen Thank you for reaching out Microsoft Fabric Community Forum
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy
Hello rbowen
Power BI Desktop uses a local engine and does not enforce the same JSON serialization limits as the Power BI Service.
you cannot directly configure or increase the `maxJsonLength` property in the Power BI Service. This property can be set in a web.config file for custom ASP.NET applications, but Power BI Service is a managed, multi-tenant environment where such configuration is not exposed to end users
• Power BI Service runs in a cloud environment, and the backend may use ASP.NET components with strict serialization limits for security and performance reasons. These limits are not user-configurable from the Power BI Desktop file (.pbix)
Hi Nilendra, and thank you. This report absolutely must do daily scheduled refreshes so how do I get around this issue?
run separate, smaller queries that keep the payload under the 32K limit.
lbendlin and nilendraFabric -
Breaking up the queries wasn't an option for this report, however, I was able to do some other tweakin in the Desktop file that resolved the issue. Thank you both very much for the information. Very helpful and actually gave me some ideas to try that ultimately fixed the issue.
Cheers.
