Push Datasets - Datasets PostRowsInGroup

Adds new data rows to the specified table within the specified dataset from the specified workspace.

Required Scope

Dataset.ReadWrite.All

Limitations

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/tables/{tableName}/rows

URI Parameters

Name In Required Type Description
datasetId
path True

string

The dataset ID

groupId
path True

string

uuid

The workspace ID

tableName
path True

string

The table name

Request Body

Name Type Description
rows

object[]

An array of data rows pushed to a dataset table. Each element is a collection of properties represented using key-value format.

Responses

Name Type Description
200 OK

OK

Examples

Example

Sample request

POST https://api.powerbi.com/v1.0/myorg/groups/f089354e-8366-4e18-aea3-4cb4a3a50b48/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

PostRowsRequest

Name Type Description
rows

object[]

An array of data rows pushed to a dataset table. Each element is a collection of properties represented using key-value format.