Forum Discussion
Combining 5 different dataset in 1 table
Hi Anonymous ,
Please check if there is any space in the column [timeliness] in 1st and 2nd table(For example: [timeliness] and [timeliness ] ), and it may cause the column [timeliness] in these two tables be identified as the column with different column names... In order to make troubleshooting and give you a suitable solution, could you please provide a simplified pbix file with only involved tables? Before share the file with us, please exclude the sensitive info in the file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
And you can review the following links to get more details of merge vs append and know the applied scenario of merge and append query...
Merge Vs. Append Concepts in Power BI (Power Query)
Append query: Combine rows from two or more tables one after another. Structure of the columns of those table should be same.
Merge query: Combine multiple queries horizontally based on standard criteria (common column) between the tables.
Append query
Merge Query
Power BI Merge Queries & Append Queries
Best Regards
Hello, i've tried to append but im having missmatch of data as i've said above. Here's the list of columns i have. The values were moving to different column. The thing is if the column timeliness is present the data from 1st table and 2nd table will be put under timeliness column but if other column werent present it will add to the right.
Hi Anonymous ,
Please check if there is any space in the column [timeliness] in 1st and 2nd table(For example: [timeliness] and [timeliness ] ), and it may cause the column [timeliness] in these two tables be identified as the column with different column names... In order to make troubleshooting and give you a suitable solution, could you please provide a simplified pbix file with only involved tables? Before share the file with us, please exclude the sensitive info in the file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
And you can review the following links to get more details of merge vs append and know the applied scenario of merge and append query...
Merge Vs. Append Concepts in Power BI (Power Query)
Append query: Combine rows from two or more tables one after another. Structure of the columns of those table should be same.
Merge query: Combine multiple queries horizontally based on standard criteria (common column) between the tables.
Append query
Merge Query
Power BI Merge Queries & Append Queries
Best Regards
Right on point!! Thank you very much!!