Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am looking for API details to create dataset with many to many cardinality relationship between tables.
I have multiple tables and I am able to give BothDirections relationships using API but unable to find any API for cardinality.
Below is API endpoint which I am using to create datasets:
https://api.powerbi.com/v1.0/myorg/groups/{ID}/datasets
Any recommendations please.
TIA.
Hi @Anonymous ,
Are you using the following REST API to create the dataset? According to my research, there is no explicit definition of the cardinality property exactly. I think it may be because power BI intelligently identifies the cardinality between tables based on the data in the tables.
Push Datasets - Datasets PostDatasetInGroup
Please review the blog below to see if you can programmatically define the cardinality value explicitly.
Programming Datasets with the Tabular Object Model (TOM)
model.Relationships.Add(new SingleColumnRelationship {
Name = "Products to Sales",
ToColumn = tableProducts.Columns["ProductId"],
ToCardinality = RelationshipEndCardinality.One,
FromColumn = tableSales.Columns["ProductId"],
FromCardinality = RelationshipEndCardinality.Many
});
Best Regards
Thank you for your response.
I tried same approach but not worked for me.
API Endpoint - https://api.powerbi.com/v1.0/myorg/groups/{ID}/datasets
Below is snippet from request:
{
"fromColumn": "judgeId",
"fromTable": "DocketJudge",
"ToCardinality": "one",
"name": "judgeEducation",
"toColumn": "judgeId",
"toTable": "JudgeEducation",
"FromCardinality": "many",
"crossFilteringBehavior": "bothDirections"
}
It failed with 400 Bad Request error saying "The property 'ToCardinality' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.Relationship"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |