Why do I see missing data in linked table

Question

This is probably a very rudimentary database type of question:

In these table attached, could someone please help and explain why do I see blanks in the joined table, in the "Zeta" column"?

Thanks for your help!

edhans · Answer

When I set that data up in my PBI desktop, my table visual only shows IDs 2 and 3.

1 and 4 are hidden from the Table A as there are no related records in table B to show. That happens as soon as I put in the Description column, which is what I would expect.

anonymous · Answer

I selected "Show items with no data", after doing so, you should see what I see from my screenshots.&nbsp;shouldn't I expect to see "B" in Zeta column for ID 1 in the join table?

edhans · Answer

Ok. then it works for me. I don't see the blanks.&nbsp;&nbsp;Maybe share a link to the PBIX file?

anonymous · Answer

What am I doing wrong?

edhans · Answer

I don't know. That is why I asked to see your PBIX file. There is somethign going on below the images that I cannot see.

Forum Discussion

Why do I see missing data in linked table

7 Replies

Related content

Missing Table from LakeHouse

PDF Export Missing HTML Table Content

missing data

Generating Missing Data

missing data