Forum Discussion
Null column after join
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!
5 Replies
Anonymous , You have merged two tables in the power query using the merge option?
Can you share sample data?
Anonymous , need sample data to test. should work if the added columns have data for that id
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
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.
