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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.