One table is blank when creating relationship

[Clayton_Von]

Greetings!

I'm new to Power BI and i have encounter a difficulties in making a relationship between tables. One of my table is not showing its contents or it is just showing blank/null values.

What i'm trying to connect here is the Family QR code from the PopCom table to the Resident Profile Family QR Code via 1 to many cardinality. 

Though the PopCom table isnt showing any values besides blank/null. And the only option that i have to use is the many to many cardinality.

It is shown that the QR Code is null.It is clearly shown here that the PopCom table has a data populated in each columns.

Thank you.

[danextian · Accepted solution]

Hi @Clayton_Von ,

What does PopCom table show in Data view. Is it blank as well? If not, it is possible that there are blank rows in this table that's been loaded into the data model.

[Clayton_Von]

Hi @danextian ,

As I have checked, it does have a blank rows included, thus i've cleaned the table first. It already shows the data now but still could not use the 1 to many cardinality.

As i've checked the other threads, it seems that I could not use it because both of my columns Family QR Code has duplicates on them (as multiple individuals are within the same family).

Thank you very much. I will just create another table that have all the list of non duplicated QR Codes and have it as a bridge.