Latest Enterprise DNA Initiatives

1 to M Relationship

Hi All,

Is it possible to create a 1 to M relationship when the actual relationship between the 2 tables is 1 to 1? I’m running into cardinality issues trying to create the 1 to M relationship.

Thank you for help.

Eric

did you let power bi to create the relationship first? Did you delete all the relationships and you created the relationship?

We would likely have to see the file to see it?
thanks
Keith

@eric_m,

As a standard practice, I change any relationship that Power BI identifies as 1:1 to 1:M (unidirectional) and can’t recall ever having a problem with that. Can you please post a screenshot of the error you’re getting, or better yet the PBIX file so we can take a look at what’s going on?

Thanks.

  • Brian
3 Likes

Brian and Keith,

I was able to troubleshoot the issue on my own. The lookup table had multiple rows where the unique identifier was blank (upstream data entry error), creating the cardinality issue with the fact tables.

Eric

@eric_m,

I’m glad you found the error. :slight_smile:
thanks
Keith