Datasets - Get Datasets

Returns a list of datasets from "My Workspace"

Required scope: Dataset.ReadWrite.All or Dataset.Read.All
To set the permissions scope, see Register an app.

GET https://api.powerbi.com/v1.0/myorg/datasets

Responses

Name Type Description
200 OK

OK

Examples

example

Sample Request

GET https://api.powerbi.com/v1.0/myorg/datasets

Sample Response

{
  "value": [
    {
      "id": "cfafbeb1-8037-4d0c-896e-a46fb27ff229",
      "name": "SalesMarketing",
      "addRowsAPIEnabled": false,
      "configuredBy": "john@contoso.com",
      "isRefreshable": true,
      "isEffectiveIdentityRequired": false,
      "isEffectiveIdentityRolesRequired": false,
      "isOnPremGatewayRequired": false
    }
  ]
}

Definitions

Column

A dataset column

CrossFilteringBehaviorEnum

The filter direction of the relationship

Dataset

A Power BI dataset

DatasetMode

The dataset mode or type, only relevant to post dataset API

Datasource

A Power BI datasource

DatasourceConnectionDetails

A Power BI datasource connection details

Measure

A Power BI measure

ODataResponse[List[Dataset]]

A dataset odata list wrapper

Relationship

A relationship between tables in a dataset

Row

A data row in a dataset

Table

A dataset table

Column

A dataset column

Name Type Description
dataType
  • string

The column data type

name
  • string

The column name

CrossFilteringBehaviorEnum

The filter direction of the relationship

Name Type Description
Automatic
  • string
BothDirections
  • string
OneDirection
  • string

Dataset

A Power BI dataset

Name Type Description
IsEffectiveIdentityRequired
  • boolean

Dataset requires effective identity

IsEffectiveIdentityRolesRequired
  • boolean

Dataset requires roles

IsOnPremGatewayRequired
  • boolean

Dataset requires on-premises data gateway

IsRefreshable
  • boolean

Can this dataset be refreshed

addRowsAPIEnabled
  • boolean

Whether dataset allows adding new rows

configuredBy
  • string

The dataset owner

datasources

The datasources associated with this dataset, only relevant to post dataset API

defaultMode

The dataset mode or type, only relevant to post dataset API

defaultRetentionPolicy
  • string

The dataset default data retention policy, only relevant to post dataset API

id
  • string

The dataset id

name
  • string

The dataset name

relationships

The dataset relationships, only relevant to post dataset API

tables

The dataset tables, only relevant to post dataset API

webUrl
  • string

The dataset web url

DatasetMode

The dataset mode or type, only relevant to post dataset API

Name Type Description
AsAzure
  • string
AsOnPrem
  • string
Push
  • string
PushStreaming
  • string
Streaming
  • string

Datasource

A Power BI datasource

Name Type Description
connectionDetails

The datasource connection details

connectionString
  • string

The datasource connection string, available only for direct query.

datasourceId
  • string

The bound datasource id, empty when not bound to a gateway

datasourceType
  • string

The datasource type

gatewayId
  • string

The bound gateway id, empty when not bound to a gateway

name
  • string

The datasource name, available only for direct query.

DatasourceConnectionDetails

A Power BI datasource connection details

Name Type Description
database
  • string

The connection database

server
  • string

The connection server

url
  • string

The connection url

Measure

A Power BI measure

Name Type Description
expression
  • string

A valid DAX expression

name
  • string

The measure name

ODataResponse[List[Dataset]]

A dataset odata list wrapper

Name Type Description
odata.context
  • string

OData context

value

The datasets

Relationship

A relationship between tables in a dataset

Name Type Description
crossFilteringBehavior

The filter direction of the relationship

fromColumn
  • string

The name of the foreign key column

fromTable
  • string

The name of the foreign key table

name
  • string

The relationship name and identifier

toColumn
  • string

The name of the primary key column

toTable
  • string

The name of the primary key table

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

measures

The measures within this table

name
  • string

The table name

rows

The data rows within this table