Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ramonmata
New Member

Error encountered by JSON parser: Unterminated string

Hi,

I am having this problem when trying to add more than 9 "rows" in a single POST to the REST API, and which accordingly with the limitations that should not be a problem

 

https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows

 

 

This is the error I am getting after the request data is sent:

 

{"error":{"code":"InvalidRequest","message":"Error parsing request for dataset sobe_wowvirtualserver|01fecc15-5954-4c6b-bbb2-d89b29bc43ca: Error encountered by JSON parser: Unterminated string. Expected delimiter: \". Path 'rows[9].Cobertura', line 1, position 3780."}}

 

 Any ideas?

 

 

best regards,

Ramon

 

1 ACCEPTED SOLUTION
ramonmata
New Member

Nevermind.... I found the problem.

 

I was calculating wrong the content lenght for the request, falling on the short side, so the server never got the complete data and parser was correctly complaining!

 

 

regards

View solution in original post

2 REPLIES 2
ramonmata
New Member

Nevermind.... I found the problem.

 

I was calculating wrong the content lenght for the request, falling on the short side, so the server never got the complete data and parser was correctly complaining!

 

 

regards

ramonmata
New Member

Hi,

I am having this problem when trying to add more than 9 "rows" in a single POST to the REST API, and which accordingly with the limitations that should not be a problem

 

https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/tables/{table_name}/rows

 

 

This is the error I am getting after the request data is sent:

 

{"error":{"code":"InvalidRequest","message":"Error parsing request for dataset sobe_wowvirtualserver|01fecc15-5954-4c6b-bbb2-d89b29bc43ca: Error encountered by JSON parser: Unterminated string. Expected delimiter: \". Path 'rows[9].Cobertura', line 1, position 3780."}}

 

 

And the json data I sent:

 

{"rows":[{"Aplicativo":"Educación a Distancia SIED","Coordinacion":"CSDISA","Coordinacion Tecnica":"CTSDIS","WBS":"1-0000011774-11","Division":"DSDIOH","Delivery Manager":"Rafael Salazar ","Service Manager":"Héctor Rodrigo Rangel Vargas","Esfuerzo Base":68.65,"UCOIs Base":0.42900000000000005,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Baja","FCFM":1.9285,"MXM":21619.91},{"Aplicativo":"ACCEDER","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":115.9,"UCOIs Base":0.7244,"Grupo":4,"Tecnologia":"Legado","Cobertura":"7X24","Criticidad":"Critica","FCFM":2.6999,"MXM":51101.61},{"Aplicativo":"Acceder Unificado","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":777.4,"UCOIs Base":4.8587,"Grupo":4,"Tecnologia":"Legado","Cobertura":"7X24","Criticidad":"Critica","FCFM":2.6999,"MXM":342773.87},{"Aplicativo":"Actualización Dato CURP","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":115.9,"UCOIs Base":0.7244,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Media","FCFM":2.117,"MXM":40068.93},{"Aplicativo":"ADIMSS","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"Sin WBS","Division":"Sin división","Delivery Manager":"Sin Delivery Manager","Service Manager":"Sin Service Manager","Esfuerzo Base":60.57,"UCOIs Base":0.3785,"Grupo":5,"Tecnologia":"Legado","Cobertura":"5x12","Criticidad":"Media","FCFM":1.99375,"MXM":19720.4},{"Aplicativo":"ADMIN","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSIIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Elizabeth Hernández López","Esfuerzo Base":777.4,"UCOIs Base":4.8587,"Grupo":5,"Tecnologia":"Legado","Cobertura":"5x12","Criticidad":"Baja","FCFM":2.918125,"MXM":370479.28},{"Aplicativo":"ADMIN SSO","Coordinacion":"CIT","Coordinacion Tecnica":"CTACVA","WBS":"1-0000011774-29","Division":"DACVASS","Delivery Manager":"Marco Antonio De la Cruz","Service Manager":"Sandra Meneses","Esfuerzo Base":60.57,"UCOIs Base":0.3785,"Grupo":1,"Tecnologia":"Multiplataforma","Cobertura":"7X24","Criticidad":"Critica","FCFM":3.85,"MXM":38080.770000000004},{"Aplicativo":"ADMPOS","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIPES","WBS":"1-0000011774-23","Division":"DSDPES","Delivery Manager":"María del Pilar Plaza Duarte","Service Manager":"Jatziry Eugenia De La Oca Vázquez","Esfuerzo Base":40.300000000000004,"UCOIs Base":0.2519,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Baja","FCFM":1.9285,"MXM":12691.17},{"Aplicativo":"ADO IMSS Digital","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSIIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Elizabeth Hernández López","Esfuerzo Base":60.57,"UCOIs Base":0.3785,"Grupo":1,"Tecnologia":"Multiplataforma","Cobertura":"7X24","Criticidad":"Critica","FCFM":5.1205,"MXM":50647.42},{"Aplicativo":"Alta Patronal Persona Física por CURP","Coordinacion":"CSDISS","Coordinacion Tecnica":"CTSDIIR","WBS":"1-0000011774-17","Division":"DSDIR","Delivery Manager":"Eric Alfonso Hernández González Y Lara","Service Manager":"Víctor Alejandro López Matus ","Esfuerzo Base":0,"UCOIs Base":0,"Grupo":6,"Tecnologia":"Legado","Cobertura":"5x8","Criticidad":"Media","FCFM":0,"MXM":0}]}

 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.