topic Re: PowerBI API not found for Cardinality(Many to Many) while creating DataSets or tables in Developer

PowerBI API not found for Cardinality(Many to Many) while creating DataSets or tables

Anonymous — Tue, 15 Nov 2022 05:41:59 GMT

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.

Re: PowerBI API not found for Cardinality(Many to Many) while creating DataSets or tables

Anonymous — Wed, 16 Nov 2022 06:43:56 GMT

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

Re: PowerBI API not found for Cardinality(Many to Many) while creating DataSets or tables

Anonymous — Mon, 21 Nov 2022 06:28:37 GMT

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"