I can batch add multiple rows with the same data to the same dataset with "try it" here⬇️ but not with Logic App...
https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-rows?tryIt=true&sour...
On Logic App, I can only add the rows one by one but not in a batch payload. This is the code I used, with the same body as the code I used in "try it" above:
"Add_rows_to_a_dataset": {
"inputs": {
"body":{
"rows": [
{
"park_id": "tdc14p6611",
"vacancy": "9",
"lastupdate": "2023-05-04T14:47:04"
},
{
"park_id": "tdc14p6620",
"vacancy": "9",
"lastupdate": "2023-05-04T14:47:04"
},
{
"park_id": "tdc14p6639",
"vacancy": "9",
"lastupdate": "2023-05-04T14:47:04"
}
]
},
"host": {
"connection": {
"name": "@parameters('$connections')['powerbi']['connectionId']"
}
},
"method": "post",
"path": "/v1.0/myorg/groups/@{encodeURIComponent('e5fbf234-4251-49ec-9312-1b1225d3f34e')}/datasets/@{encodeURIComponent('b44b5542-034e-4c0b-8d83-2c72bde24e8c')}/tables/@{encodeURIComponent('parking-vacancy?format=json')}/rows",
"queries": {
"pbi_source": "powerAutomate"
}
},
"runAfter": {},
"type": "ApiConnection"
},
This is the error that I am receiving.. logic app keeps reading "rows" as a column, instead of well, rows.
{
"error": {
"code": "ItemNotFound",
"message": "Column '<pi>rows</pi>' was not found in specified table, dataset 'sobe_wowvirtualserver|b44b5542-034e-4c0b-8d83-2c72bde24e8c'"
}
}
Any ideas? thanks for your time!
