Push Datasets - Datasets PutTableInGroup

Updates the metadata and schema for the specified table within the specified dataset from the specified workspace.

Required scope

Dataset.ReadWrite.All

Limitations

This API only supports push datasets.

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

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 Required Type Description
columns True

The column schema for this table

name True
  • string

The table name

description
  • string

The table description

isHidden
  • boolean

(Optional) Whether this dataset table is hidden

measures

The measures within this table

rows

The data rows within this table

source

The table source

Responses

Name Type Description
200 OK

OK

Examples

example

Sample Request

PUT https://api.powerbi.com/v1.0/myorg/groups/f089354e-8366-4e18-aea3-4cb4a3a50b48/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/tables/Product
{
  "tableName": "NewProduct",
  "columns": [
    {
      "name": "ProductID",
      "dataType": "Int64"
    },
    {
      "name": "Name",
      "dataType": "string"
    },
    {
      "name": "Category",
      "dataType": "string"
    },
    {
      "name": "IsCompete",
      "dataType": "bool"
    },
    {
      "name": "ManufacturedOn",
      "dataType": "DateTime"
    },
    {
      "name": "NewColumn",
      "dataType": "string"
    }
  ]
}

Sample Response

{
  "name": "NewProduct"
}

Definitions

ASMashupExpression

A dataset table source

Column

A dataset column

Measure

A Power BI measure

Row

A data row in a dataset

Table

A dataset table

ASMashupExpression

A dataset table source

Name Type Description
expression
  • string

The source expression

Column

A dataset column

Name Type Description
dataCategory
  • string

(Optional) String value to be used for the data category which describes the data within this column

dataType
  • string

The column data type

formatString
  • string

(Optional) The format of the column as specified in FORMAT_STRING

isHidden
  • boolean

(Optional) Property indicating if the column is hidden from view. Default is false.

name
  • string

The column name

sortByColumn
  • string

(Optional) String name of a column in the same table to be used to order the current column

summarizeBy
  • string

(Optional) Aggregate Function to use for summarizing this column

Measure

A Power BI measure

Name Type Description
description
  • string

(Optional) Measure description

expression
  • string

A valid DAX expression

formatString
  • string

(Optional) A string describing how the value should be formatted when it is displayed as specified in FORMAT_STRING

isHidden
  • boolean

(Optional) Is measure hidden

name
  • string

The measure name

Row

A data row in a dataset

Name Type Description
id
  • string

The unique row ID

Table

A dataset table

Name Type Description
columns

The column schema for this table

description
  • string

The table description

isHidden
  • boolean

(Optional) Whether this dataset table is hidden

measures

The measures within this table

name
  • string

The table name

rows

The data rows within this table

source

The table source