Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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}]}
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |