Forum Discussion

UmeshGoti's avatar
UmeshGoti
Helper I
1 year ago
Solved

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

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=HTTP&tryIt=true&source=docs#code-try...
"Power BI Report Server "
"Semantic Model"
'Need help'
microsoft fabric
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

UmeshGoti's avatar
UmeshGoti
Helper I
1 year ago

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's avatar
Anonymous
Not applicable
1 year ago

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