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 only supports push datasets.

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) 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

Tables

The OData response wrapper for a Power BI table collection

Name Type Description
odata.context
  • string

OData context

value

The Power BI tables