Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Team,
I created this thread previosly, however, im unable to see it in my messages not visible in the forum questions as well. Hence, creating it as a new thread again. sorry for the duplication.
I have two datasets which we are getting from API calls. Both have almost similar data but columns are not in order.
For example, Query1 fetches 10 columns & Query 2 fetches 9 columns with headers below.
Column Number | Query 1 Column Headers | Query 2 Column Headers |
1 | Column1._index | Column1._index |
2 | Column1._type | Column1._type |
3 | Column1._id | Column1._id |
4 | Column1._score | Column1._score |
5 | Column1._source.CallRate | Column1._source.Audio.Incoming.PacketLoss |
6 | Column1._source.deviceType | Column1._source.Video.Outgoing.PacketLossPercent |
7 | Column1._source.DaysAgo | Column1._source.Video.Incoming.MaxJitter |
8 | Column1._source.EncryptionType | Column1._source.videoPacketLossPercentage |
9 | Column1._source.Audio.Incoming.PacketLoss | Column1._source.DisconnectCauseType |
10 | Column1._source.Video.Outgoing.PacketLossPercent |
Now, when i try to append these two queries, the columns from query 2 are not appending to the correct columns in Query 1 as they are not in alphabetic order or any sort of order.
If you notice the columns below from Query 2 should get appended with same columns in Query 1.
Column1._source.Audio.Incoming.PacketLoss
Column1._source.Video.Outgoing.PacketLossPercent
Currently, its getting appended to Column1._source.CallRate & Column1._source.deviceType respectively in Query 1.
How can I manage to get this work? Kindly help.
Solved! Go to Solution.
@LP2803 , if you have the same name as the colums, You can rename and have the same name then Append can do the task easily
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@LP2803 , if you have the same name as the colums, You can rename and have the same name then Append can do the task easily
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@amitchandak Thanks Amit,
Yes, If the column names are same it appends the data to the appropriate columns irrespecitve of the columns position. I did a check and understood how it does.
Thanks a lot for clarifying.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
61 | |
46 | |
45 |