Power BI · Schema

Relationship

A relationship between two tables in a dataset

AnalyticsBusiness IntelligenceDashboardsData AnalysisReportingVisualization

Properties

Name Type Description
name string The name of the relationship
fromTable string The source table name
fromColumn string The source column name
toTable string The target table name
toColumn string The target column name
crossFilteringBehavior string The cross-filtering direction
View JSON Schema on GitHub

JSON Schema

power-bi-relationship-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/Relationship",
  "title": "Relationship",
  "type": "object",
  "required": [
    "name",
    "fromTable",
    "fromColumn",
    "toTable",
    "toColumn"
  ],
  "description": "A relationship between two tables in a dataset",
  "properties": {
    "name": {
      "type": "string",
      "description": "The name of the relationship",
      "example": "Example Title"
    },
    "fromTable": {
      "type": "string",
      "description": "The source table name",
      "example": "example_value"
    },
    "fromColumn": {
      "type": "string",
      "description": "The source column name",
      "example": "example_value"
    },
    "toTable": {
      "type": "string",
      "description": "The target table name",
      "example": "example_value"
    },
    "toColumn": {
      "type": "string",
      "description": "The target column name",
      "example": "example_value"
    },
    "crossFilteringBehavior": {
      "type": "string",
      "description": "The cross-filtering direction",
      "enum": [
        "OneDirection",
        "BothDirections",
        "Automatic"
      ],
      "example": "OneDirection"
    }
  }
}