Need to establish relation between tables in create semantic API for PowerBi Service

[UmeshGoti]

Currently i am able to create semantic layer through fabric API
(https://learn.microsoft.com/en-us/rest/api/fabric/semanticmodel/items/create-semantic-model?tabs=HTT...)

In above API i am passing request body which can contain multiple tables definition(in Base64 Format) but currently i am unable to provide relationships among those tables.

can someone please help on how to provide relationships among provided tables in request body in create semantic API

Thanks in advance !!

[UmeshGoti]

here is sample JSON with two tables
{
"name": "SalesModel1",
"compatibilityLevel": 1550,
"model": {
"culture": "en-US",
"dataAccessOptions": {
"legacyRedirects": true,
"returnErrorValuesAsNull": true
},
"defaultPowerBIDataSourceVersion": "powerBI_V3",
"sourceQueryCulture": "en-US",
"tables": [
{
"name": "Claim_asof_fact",
"lineageTag": "eaf4ab7c-3bdd-437c-bd9d-8d6f1de2eb12",
"columns": [
{
"name": "OPEN_CLAIM_COUNT",
"dataType": "Int64",
"isNullable": false,
"sourceColumn": "OPEN_CLAIM_COUNT",
"sourceProviderType": "int",
"lineageTag": "4e475557-0a24-43ff-b93e-e7a75fd3895c",
"summarizeBy": "none",
"annotations": [
{
"name": "SummarizationSetBy",
"value": "Automatic"
}
]
}
],
"partitions": [
{
"name": "Applications",
"mode": "directQuery",
"source": {
"type": "m"
}
}
],
"annotations": [
{
"name": "PBI_ResultType",
"value": "Table"
}
]
},
{
"name": "Claim_asof_fact2",
"lineageTag": "eaf4ab7c-3bdd-437c-bd9d-8d6f1de2eb12",
"columns": [
{
"name": "OPEN_CLAIM_COUNT",
"dataType": "Int64",
"isNullable": false,
"sourceColumn": "OPEN_CLAIM_COUNT",
"sourceProviderType": "int",
"lineageTag": "4e475557-0a24-43ff-b93e-e7a75fd3895n",
"summarizeBy": "none",
"annotations": [
{
"name": "SummarizationSetBy",
"value": "Automatic"
}
]
}
],
"partitions": [
{
"name": "Applications",
"mode": "directQuery",
"source": {
"type": "m"
}
}
],
"annotations": [
{
"name": "PBI_ResultType",
"value": "Table"
}
]
}
],
"cultures": [
{
"name": "en-US",
"linguisticMetadata": {
"content": {
"Version": "1.0.0",
"Language": "en-US"
},
"contentType": "json"
}
}
],
"annotations": [
{
"name": "PBI_QueryOrder",
"value": "[\"Applications\"]"
},
{
"name": "__PBI_TimeIntelligenceEnabled",
"value": "1"
},
{
"name": "PBIDesktopVersion",
"value": "2.137.1102.0 (24.10)"
},
{
"name": "PBI_ProTooling",
"value": "[\"DevMode\"]"
},
{
"name": "TabularEditor_SerializeOptions",
"value": "{\"IgnoreInferredObjects\":true,\"IgnoreInferredProperties\":true,\"IgnoreTimestamps\":true,\"SplitMultilineStrings\":true,\"PrefixFilenames\":false,\"LocalTranslations\":false,\"LocalPerspectives\":false,\"LocalRelationships\":false,\"Levels\":[\"Data Sources\",\"Shared Expressions\",\"Perspectives\",\"Relationships\",\"Roles\",\"Tables\",\"Tables/Columns\",\"Tables/Hierarchies\",\"Tables/Measures\",\"Tables/Partitions\",\"Tables/Calculation Items\",\"Translations\"]}"
},
{
"name": "__TEdtr",
"value": "1"
}
]
}
}

[Anonymous · Accepted solution]

Hi @UmeshGoti ,

Please try to include the relationships in your JSON request body to establish relationships between tables in the semantic model for Power BI Service using the Fabric API, later check if it can work or not:

  "relationships": [
      {
        "name": "Relationship1",
        "fromTable": "Claim_asof_fact",
        "fromColumn": "OPEN_CLAIM_COUNT",
        "toTable": "Claim_asof_fact2",
        "toColumn": "OPEN_CLAIM_COUNT",
        "crossFilteringBehavior": "oneDirection",
        "relationshipType": "regular"
      }
    ]

Best Regards