Forum Discussion
Cardinality you selected isn't valid
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.
Resident RockstarHi 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
Cherry, Thank you so much for your reply.
I am using Directquery, so I am not able to create DAX query table for calendar date, if composite model is unchecked. My funded_date column has no null but repeatitive values. Please suggest how to solve this problem!
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.
- v-piga-msft
Hi Anonymous,
It seems that you have solved your problem. Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry