Dataset Schema - Retrieves the dataset schema

Retrieves the schema of tables from a Power BI dataset.

get
Authorizations
Path parameters
workspaceIdstringRequired

The ID of the Power BI workspace.

datasetIdstringRequired

The ID of the Power BI dataset.

Query parameters
versionstringOptional

The requested API version

Default: 1.0
Responses
200

Success

get
GET /workspace/{workspaceId}/dataset/{datasetId}/datasetSchema HTTP/1.1
Host: 
Authorization: Bearer JWT
Accept: */*
[
  {
    "tableName": "text",
    "isCalculatedTable": true,
    "tableExpression": "text",
    "columns": [
      {
        "columnName": "text",
        "dataType": "text",
        "type": 1,
        "columnExpression": "text"
      }
    ],
    "measures": [
      {
        "measureName": "text",
        "measureExpression": "text"
      }
    ],
    "relationships": [
      {
        "fromTable": "text",
        "fromColumn": "text",
        "fromCardinality": "text",
        "toTable": "text",
        "toColumn": "text",
        "toCardinality": "text",
        "crossFilterDirection": "text",
        "securityFilteringBehavior": "text",
        "isActive": true
      }
    ]
  }
]

Last updated