Forum Discussion
Merging multiple csv files as importing to Power Bi
Hi mates, I have got multiple csv files to be imported to Power Bi. They all have the same number of rows but different columns hence, need to be merged and not appended. When using the Power Bi def...
Alirezam , Append should work as you will have additional columns where the column name do not match.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://www.youtube.com/watch?v=4fFL7Ok7Ovg
Dax : https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Prefer the option of merge in data transformation
Thanks,
My problem is not with the queries. My question was when you import the csv files. when you select the multiple csv files to import, the Combine option only append the files
