Push Datasets - Datasets PostRows

Service:
Power BI REST APIs
API Version:
v1.0

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
datasetId
 path True
  • string

The dataset id
tableName
 path True
  • string

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
Request Body
{
  "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

Status code:
200

Definitions

Object
PostRowsRequest

Object

PostRowsRequest

Name Type Description
rows

An array of data rows pushed to a dataset table