Forum Discussion
Append Data from different source and Add custom column depends on the source
1. Create a folder. Put all your csv in this folder.
2. Back in Power BI Desktop load instead of the csv file the folder.
By connecting to a folder, you can import data from multiple files at once, such as a series of Excel files of CSV files.
The files contained within your selected folder appear in Query Editor as binary content, and clicking the double-arrow icon at the top of the Content column loads their values.
Hope this helps.
Anonymous
Thank you so much for showing me how to get data from a folder instead of files.
1 more question, how to add 1 more column to define which row this comes from (either first file, second, etc).
Thank you.
Hi ngadiez,
There is no such a date column in source table, right? If so, it is not available to add a new column that can distinguish which row belongs to which month data. In your scenario, you could add a custom column inside each table imported from each file to display corresponding date before you append these tables. Then, combine the table one by one.
Regards,
Yuliana Gu