Push Datasets - Datasets GetTables

Service:

Power BI REST APIs

API Version:

v1.0

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