Forum Discussion
Cardinality you selected isn't valid
Hi,
I am not able to publish my report, so I found out the cause and came to know that in my preview feature composite model is checked. I tried unchecking it, but it won't let me open power bi report. From power bi community I learned, if there is many to many relationship active, we cannot publish a report.
Now, problem is I have a coulmn named Admission_date and Date. Admission_date can be repeatitive, as multiple people can get admission in a day. But, my Date column has non-repeative date as it is a DAX query generated calendar date column. I am not able to create many to one relationship. It says "cardinality you selected isn't valid for this relationship".
Is it due to null values in admission_date column? Should I put null in Date column too, if yes how can I do it, as date column is system generated.
Any help?
So, what I did is- deleted the table which I was able to create because my composite model was checked. But, since unchecking composite model feature will not let me open my power bi desktop. So I deleted the table in power bi and created and pulled from SQL Server. So I was able to create one to many relationship and publish my report.
4 Replies
v-piga-msftResident Rockstar
Hi Anonymous,
Firstly, you should unclicked the option composite model.
In additon, by my tests, I created a date column incluing null value and repeat values, created a date table with calendar function .
I also could create the Many to one relationship between the tables.
Please check your data model and if you still need help, please share your data model so that we could help further on it?
Best Regards,
Cherry
So, what I did is- deleted the table which I was able to create because my composite model was checked. But, since unchecking composite model feature will not let me open my power bi desktop. So I deleted the table in power bi and created and pulled from SQL Server. So I was able to create one to many relationship and publish my report.