Forum Discussion
Load multiple csv files and combine them
I need to load 300+ csv files into a PowerBI, then combine some of them using “Append” function. They may have different number of columns, so I can’t use “Combine Files”. It shifts the data to the c...
Yikes. That sounds like quite the mess. Obviously, to combine files, they need to have consistent columns, in both name and order. Depending on how much these files vary, you could be able to create a query function that transforms the files into the desired format before combining. Best of luck!
Thank you.
I am trying to find a more flexible solution, in case there are more columns been added later on. The data source came from a survey result and they may add more questions in the future (which will result in more columns).
The Append function in Power BI works well as it will dectcte the column headers and merge the columsn with the same header, and add "null" value to those columns that may not exist in a file.