Save the File name when Combining CSV Binary

[Anonymous]

I am trying to import a file that has about 10,000 files in it. They are CSV files, when I import them I get the columns Name (for the file name) and Content (with the binary file). I want to keep the file name associated with all data on the Binary file - make sure there is a column for the name once the binary files are combined so I can tell the different source for each piece of information. Since there are so many files I dont want to have to add a custom column to add the file names. 

When I try to just combine the binary the first column - the file name - always disappears. Thanks! 

[Anonymous]

Here is what I'm looking at...I want to keep the Name and open the Binary to include all data and their sources...any advice? 

[Sean · Accepted solution]

@Anonymous Not sure if this will help you but check this out...

http://community.powerbi.com/t5/Desktop/Retain-file-name-column-when-using-Folder-as-a-data-source-Power/m-p/22851/highlight/true#M7240

[Anonymous]

Yes! Thank you! I just found that myself and it works perfectly!