Dataset Schema - Retrieves the dataset schema

Retrieves the schema of tables from a Power BI dataset.

get

Authorizations

Bearer

HTTPRequired

Please enter a valid token

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

/workspace/{workspaceId}/dataset/{datasetId}/datasetSchema

HTTPcURLJavaScriptPython

GET /workspace/{workspaceId}/dataset/{datasetId}/datasetSchema HTTP/1.1
Host: 
Authorization: Bearer YOUR_SECRET_TOKEN
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
      }
    ]
  }
]