Dataset Schema - Retrieves the dataset schema

Retrieves the schema of tables from a Power BI dataset.

get

Authorizations

Bearer

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

text/plainapplication/jsontext/json

400

Bad Request

text/plainapplication/jsontext/json

404

Not Found

text/plainapplication/jsontext/json

500

Server Error

text/plainapplication/jsontext/json

get

HTTPcURLJavaScriptPython

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
      }
    ]
  }
]