Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
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
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}]}
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
3 |