Null column after join

[Anonymous]

Hello!

I'm trying to join 2 tables, and if I show only ID column everything is fine, but when I show 2 columns PowerBI makes null columns everywhere. How can I fix it? Thank you in advance!

[v-yalanwu-msft]

Hi, @Anonymous ;

Can you give a simple sample and then give the result you want to output? Are the columns merged from two tables or one table?

It makes it easier to give you a solution.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

I think you need to recheck the merge option that you have used.

Here's a link to understand the concept: Merge Options in Power BI - Power BI Training Australia

[amitchandak]

@Anonymous , You have merged two tables in the power query using the merge option?

Can you share sample data?

[Anonymous]

yes, this one 

[amitchandak]

@Anonymous , need sample data to test. should work if the added columns have data for that id