Push Datasets - Datasets GetTables

Returns a list of tables within the specified dataset from My workspace.

Required Scope

Dataset.ReadWrite.All or Dataset.Read.All

Limitations

This API call only supports push datasets. For a complete list of limitations, see Push datasets limitations.

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/tables

URI Parameters

Name In Required Type Description
datasetId
path True
  • string

The dataset ID

Responses

Name Type Description
200 OK

OK

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

Tables

The OData response wrapper for a Power BI table collection

ASMashupExpression

A dataset table source

Name Type Description
expression
  • string

The source expression

Column

A dataset column

Name Type Description
dataCategory
  • string

Optional. The 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. Whether the column is hidden. The 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. The aggregate function to use for summarizing this column.

Measure

A Power BI measure

Name Type Description
description
  • string

Optional. The measure description.

expression
  • string

A valid DAX expression

formatString
  • string

Optional. A string describing how the value should be formatted when it's displayed as specified in FORMAT_STRING.

isHidden
  • boolean

Optional. Whether the measure is 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

Tables

The OData response wrapper for a Power BI table collection

Name Type Description
odata.context
  • string

OData context

value

The Power BI tables