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}/tablesURI Parameters
| Name | In | Required | Type | Description |
|---|---|---|---|---|
|
dataset
|
path | True |
string |
The dataset ID |
Responses
| Name | Type | Description |
|---|---|---|
| 200 OK |
OK |
Definitions
| Name | Description |
|---|---|
|
ASMashup |
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 |
| name |
string pattern: ^[\x09\x0A\x0D\x20-\uD7FF\uE000-\uFFFD\u10000-\u10FFFF]+$ |
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 pattern: ^[\x09\x0A\x0D\x20-\uD7FF\uE000-\uFFFD\u10000-\u10FFFF]+$ |
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 pattern: ^[\x09\x0A\x0D\x20\x23\x2D\x30-\x39\x40-\x5A\x5E-\x5F\x61-\x7A\x7E-\uD7FF\uE000-\uFFFD\u10000-\u10FFFF]{1,100}$ |
The table name |
| rows |
Row[] |
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 |
Table[] |
The Power BI tables |