Relationship Issue

[aaditya2000]

Hello:

Relationship is active & is formed Many-to-One from Table A to Table B. I have data on both the tables (A & B).

The problem i am facing in Power BI Table visulization, is when i add couple of columns from B, i see data in table and moment i add data from A in table, both columns for B display empty and if remove data for A, i see data for B.

Did someone has experience similar issue?

Any help is greatly appreciated.

[v-yulgu-msft · Accepted solution]

Hi @aaditya2000,

As the relationship is many to one from A to B, that means there existing some records in TableB cannot find the matched one in TableA. So, when you add data from A into visual, some records under columns of Table B show blank.

Regards,

Yuliana Gu