Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
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
@Anonymous , You have merged two tables in the power query using the merge option?
Can you share sample data?
yes, this one
@Anonymous , need sample data to test. should work if the added columns have data for that id
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |