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: The schema of the tables was successfully retrieved.

text/plain

400

Bad Request: The request could not be processed due to invalid syntax or missing/incorrect parameters.

text/plain

404

Not Found: The workspace or dataset was not found, the URL is invalid, or the resource has been deleted.

text/plain

500

Internal Server Error: An unexpected error occurred or a server timeout.

text/plain

get

HTTPcURLJavaScriptPython

GET /workspace/{workspaceId}/dataset/{datasetId}/datasetSchema HTTP/1.1
Host: admin-embedfastdev-app.azurewebsites.net
Authorization: Bearer JWT
Accept: */*

[
  {
    "tableName": "text",
    "isCalculatedTable": true,
    "tableExpression": "text",
    "columns": [
      {
        "columnName": "text",
        "dataType": "text",
        "type": "text",
        "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
      }
    ]
  }
]