Push Datasets - Datasets PostRows
Adds new data rows to the specified table within the specified dataset from "My Workspace".
Note: This API supports only Push datasets.
REST API Limitations: See Power BI REST API limitations.
Required scope: Dataset.ReadWrite.All
To set the permissions scope, see Register an app.
POST https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/tables/{tableName}/rows
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
dataset
|
path | True |
|
The dataset id |
table
|
path | True |
|
The table name |
Request Body
Name | Type | Description |
---|---|---|
rows |
|
An array of data rows pushed to a dataset table |
Responses
Name | Type | Description |
---|---|---|
200 OK |
OK |
Examples
example
Sample Request
POST https://api.powerbi.com/v1.0/myorg/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/tables/Product/rows
{
"rows": [
{
"ProductID": 1,
"Name": "Adjustable Race",
"Category": "Components",
"IsCompete": true,
"ManufacturedOn": "07/30/2014"
},
{
"ProductID": 2,
"Name": "LL Crankarm",
"Category": "Components",
"IsCompete": true,
"ManufacturedOn": "07/30/2014"
},
{
"ProductID": 3,
"Name": "HL Mountain Frame - Silver",
"Category": "Bikes",
"IsCompete": true,
"ManufacturedOn": "07/30/2014"
}
]
}
Sample Response
Definitions
Object | |
Post |
Object
PostRowsRequest
Name | Type | Description |
---|---|---|
rows |
|
An array of data rows pushed to a dataset table |