The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm having an issue where, when I try to append two queries, the additional column from the second query is in the combined query, but all records are null.
For example:
Query A:
ID Column1 Column2
1 aaa bbb
2 ccc ddd
Query B:
ID Column1 Column2 Column3
3 eee fff ggg
4 hhh jjj kkk
Appending Query B to Query A should result in:
ID Column1 Column2 Column3
1 aaa bbb null
2 ccc ddd null
3 eee fff ggg
4 hhh jjj kkk
However, I'm getting this:
ID Column1 Column2 Column3
1 aaa bbb null
2 ccc ddd null
3 eee fff null
4 hhh jjj null
I'm using the ribbon buttons to do this. Here is the code that is being auto-generated:
= Table.Combine({#"Table A", #"Table B"})
Can anyone explain why I'm getting all nulls for Column3?
Thanks in advance for your help!
Solved! Go to Solution.
Thanks all for your help, but I think I've figured it out. The append is actually working. It's just that the preview isn't showing all records (the actual tables are much larger than what my example shows). I'm new to PowerBI, and didn't realize that this was due to the preview.
Thanks again for your help!
Hi
I tried to reproduce your error , but getting the right data only.
Are you sure you are have the right data i nthe table?
Thanks
Raj
I do have more information on this issue. When I do the append, the extra column is null for all records. When I click on the down arrow button for the column, and then click on "Load More", then I see all values show up. But, once I click on OK, it referts back to the column being null for all records.
However, if, immediately after clicking on "Load More", I filter on any one value, that value will be visible. But, as soon as I choose "Select All", they all go back to null again.
Thanks all for your help, but I think I've figured it out. The append is actually working. It's just that the preview isn't showing all records (the actual tables are much larger than what my example shows). I'm new to PowerBI, and didn't realize that this was due to the preview.
Thanks again for your help!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |