Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 r...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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! 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    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