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

Tables

OK

Definitions

Name Description
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

Column[]

The column schema for this table

description

string

The table description

isHidden

boolean

Optional. Whether this dataset table is hidden.

measures

Measure[]

The measures within this table

name

string

The table name

rows

Row[]

The data rows within this table

source

ASMashupExpression[]

The table source

Tables

The OData response wrapper for a Power BI table collection

Name Type Description
odata.context

string

OData context

value

Table[]

The Power BI tables